252145_ko-KR

liliconcom

하나의 열에서 전체 테이블을로 나누는 방법은 무엇입니까?

H 이제 한 테이블에서 전체 테이블을로 나눕니 까?

아래 그림에서 볼 수 있듯이 열 전체에서를 통해 전체 케이블을 다이빙하고 싶습니다!

그래서 스크립트를 만들었지 만 연결 코드는 작동하지 않습니다.

또한가 너무 많으면이 스크립트가 매우 비효율적입니다.

코드를보다 효율적으로 변경하려면 어떻게해야합니까? (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...

Re : 한 열에서 전체 테이블을로 나누는 방법은 무엇입니까?

내 첫 번째 코멘트는 

     텍스트를 열로 ()

함수를 사용하면 C1, C2 등의 값을 자체 열로 나눌 수 있습니다.  이렇게하면 코드를 통해 작업하는 동안 이점을 얻을 수 있습니다.

또한 도움이되는 Word () 함수를보십시오.

마지막으로 아래는 연결 코드의 변경 사항으로, 다음과 같습니다.

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

 

Re : 한 열에서 전체 테이블을로 나누는 방법은 무엇입니까?

오 감사 

이 코드를 다시 만들었지 만 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 )
 );

 
 
 
 
);