topic Combine columns which contain specific substring in their name in Discussions

Combine columns which contain specific substring in their name

AdirZig — Fri, 09 Jun 2023 18:02:11 GMT

Hi,

I am trying to combine only the columns in Data table "dtPatList" which contain the substring "INIT" in their name, but it doesn't work.

I understand that the problem related to the parameter I bolded below. could someone advise for the right way?

Thanks!!

// get the dt cols names

nc = ncols(dtPatList);

// get the dt cols names

col_list = dtPatList << get column names(string);

for (i = nitems(col_list), i > 0, i--,

if (!contains(col_list[i], "INIT")), /// new ps columns

remove from(col_list, i);

)

);

//Combine init cols

dtPatList << Combine Columns(

delimiter( "_" ),

Columns(col_list),

Selected Columns are Indicator Columns( 0 ),

Column Name( "INIT_Chain" )

);

Re: Combine columns which contain specific substring in their name

jthi — Tue, 12 Oct 2021 16:06:19 GMT

Try adding Eval() inside Columns:

Columns(Eval(col_list))

Re: Combine columns which contain specific substring in their name

txnelson — Tue, 12 Oct 2021 16:39:41 GMT

You need to place an eval() function around the col_list, to have it expanded in the function Combine Columns execution.

// get the dt cols names
dtPatlist = current data table();
nc = N Cols( dtPatList );

 

// get the dt cols names

col_list = dtPatList << get column names( string,character );

For( i = N Items( col_list ), i > 0, i--, 

	If( !Contains( col_list[i], "INIT" ), /// new ps columns

		Remove From( col_list, i );

	)    

);

 

//Combine init cols 

dtPatList << Combine Columns(

delimiter( "_" ),

Columns(eval(col_list)),

Selected Columns are Indicator Columns( 0 ),

Column Name( "INIT_Chain" )

);