252145_ja-JP

liliconcom

1つの列で、テーブル全体をで分割するにはどうすればよいですか？

H テーブル全体を1つの列でで分割しますか？

下の写真に示すように、列全体で、全体の聖書を掘り下げたいと思います！

そのため、スクリプトを作成しましたが、連結コードは機能していません。

また、が非常に多い場合、このスクリプトは非常に非効率的です。

コードをより効率的に変更するにはどうすればよいですか？（forまたはwhileを使用していますか？）

 

 

 

 

dt = current data table();

newdt = dt << Subset( Output Table Name( "Graph table" ), All Columns( 1 ), All Rows( 1 ) ) ;


newdt << Select Where( Contains ( :As is Config , ",")) ;

newdt2 = newdt << Subset( Output Table Name( "Subset1" ), All Columns( 1 ), Selected Rows( 1 ) ) ;


newdt << new column("new As is Config", Formula(Left( :As is Config, Contains( :As is Config, "," ) - 1 ))); 
column(newdt, "new As is Config" ) << Eval Formula; 
column(newdt, "new As is Config") << Delete Column Property( "Formula" ); 
column(newdt, "As is Config" ) << Formula(:new As is Config);
column(newdt, "As is Config" ) << Eval Formula; 
column(newdt, "As is Config") << Delete Column Property( "Formula" );  
newdt << Delete Columns( "new As is Config" ); 

 

newdt2 << new column("new As is Config", Formula(Substr(:As is Config, Contains( :As is Config, "," ) + 1, 100))); 
column(newdt2, "new As is Config" ) << Eval Formula; 
column(newdt2, "new As is Config") << Delete Column Property( "Formula" );
column(newdt2, "As is Config" ) << Formula(:new As is Config);
column(newdt2, "As is Config" ) << Eval Formula; 
column(newdt2, "As is Config") << Delete Column Property( "Formula" );  
newdt2 << Delete Columns( "new As is Config" ); 

newdt2 << Select Where( Contains ( :As is Config , ",")) ;

newdt3 = newdt2 << Subset( Output Table Name( "Subset2" ), All Columns( 1 ), Selected Rows( 1 ) ) ;



newdt2 << new column("new As is Config", Formula(Left( :As is Config, Contains( :As is Config, "," ) - 1 ))); 
column(newdt2, "new As is Config" ) << Eval Formula; 
column(newdt2, "new As is Config") << Delete Column Property( "Formula" );   
column(newdt2, "As is Config" ) << Formula(:new As is Config);
column(newdt2, "As is Config" ) << Eval Formula; 
column(newdt2, "As is Config") << Delete Column Property( "Formula" );  
newdt2 << Delete Columns( "new As is Config" ); 

 


newdt3 << new column("new As is Config", Formula(Substr(:As is Config, Contains( :As is Config, "," ) + 1, 100))); 
column(newdt3, "new As is Config" ) << Eval Formula; 
column(newdt3, "new As is Config") << Delete Column Property( "Formula" );   
column(newdt3, "As is Config" ) << Formula(:new As is Config);
column(newdt3, "As is Config" ) << Eval Formula; 
column(newdt3, "As is Config") << Delete Column Property( "Formula" ); 
newdt3 << Delete Columns( "new As is Config" ); 

newdt3 << Select Where( Contains ( :As is Config , ",")) ;

newdt4 = newdt3 << Subset( Output Table Name( "Subset3" ), All Columns( 1 ), Selected Rows( 1 ) ) ;



newdt3 << new column("new As is Config", Formula(Left( :As is Config, Contains( :As is Config, "," ) - 1 ))); 
column(newdt3, "new As is Config" ) << Eval Formula; 
column(newdt3, "new As is Config") << Delete Column Property( "Formula" ); 
column(newdt3, "As is Config" ) << Formula(:new As is Config);
column(newdt3, "As is Config" ) << Eval Formula; 
column(newdt3, "As is Config") << Delete Column Property( "Formula" );  
newdt3 << Delete Columns( "new As is Config" ); 

both = newdt << concatenate( Graph table, Subset1, Subset2, "Append to first Table"); // this code is not working...

再：どのように私は1列で、テーブル全体を分割するのですか？

私の最初のコメントは、 

     列へのテキスト（）

関数を使用すると、C1、C2などの値を独自の列に分割できます。  これにより、コードの作業中に利点が得られる場合があります。

Word（）関数もご覧ください。

最後に、連結コードの変更を以下に示します。これはあなたに役立つはずです。

both = newdt << concatenate( Data Table("Graph table"),
Data Table("Subset1"),
Data Table("Subset2"),
 Append to first Table(1));

 

再：どのように私は1列で、テーブル全体を分割するのですか？

ああ、ありがとう 

このコードを作り直しましたが、TTは動作しません 

何が問題ですか？？このスクリプトでは...

 

Names Default To Here( 1 );

dt = Current Data Table();




newdt = dt << Subset( Output Table Name( "Graph table" ), All Columns( 1 ), All Rows( 1 ) );
//Graph table 


newdt << Select columns( :As is Config );

N = newdt << Subset( Output Table Name( "N" ), Selected Columns( 1 ), All Rows( 1 ) );

nColNow = N Items( n << get column names );
n << text to columns( delimiter( "," ), columns( :As is Config ) );
colAdded = N Items( n << get column names ) - nColNow;

For( i = 1, i <= colAdded, i++, 
 
 newdt[i] << Select Where( Contains( :As is Config, "," ) );
 newdt[i + 1] = newdt << Subset( Output Table Name( "Subset" ), All Columns( 1 ), Selected Rows( 1 ) );

 newdt[i] << New Column( "new As is Config",
  Formula( Left( :As is Config, Contains( :As is Config, "," ) - 1 ) )
 );
 Column( newdt[i], "new As is Config" ) << Eval Formula; //Formula 특성 계싼!!
 Column( newdt[i], "new As is Config" ) << Delete Column Property( "Formula" );  //formula 특성 지우기 
 Column( newdt[i], "As is Config" ) << Formula( :new As is Config );
 Column( newdt[i], "As is Config" ) << Eval Formula; //Formula 특성 계싼!!
 Column( newdt[i], "As is Config" ) << Delete Column Property( "Formula" );  //formula 특성 지우기
 newdt[i] << Delete Columns( "new As is Config" ); // new As is Config 삭제!!


 newdt[i + 1] << New Column( "new As is Config",
  Formula( Substr( :As is Config, Contains( :As is Config, "," ) + 1, 100 ) )
 );
 Column( newdt[i + 1], "new As is Config" ) << Eval Formula; //Formula 특성 계싼!!
 Column( newdt[i + 1], "new As is Config" ) << Delete Column Property( "Formula" );  //formula 특성 지우기 
 Column( newdt[i + 1], "As is Config" ) << Formula( :new As is Config );
 Column( newdt[i + 1], "As is Config" ) << Eval Formula; //Formula 특성 계싼!!
 Column( newdt[i + 1], "As is Config" ) << Delete Column Property( "Formula" );  //formula 특성 지우기 
 newdt[i + 1] << Delete Columns( "new As is Config" ); // new As is Config 삭제!!

 newdt[i + 1] << Select Where( Contains( :As is Config, "," ) );

 newdt[i + 2] = newdt[i + 1] << Subset(
  Output Table Name( "Subset" ),
  All Columns( 1 ),
  Selected Rows( 1 )
 );

 
 
 
 
);