create subset with list of columns

avner8943 — Thu, 05 Dec 2019 22:12:07 GMT

Hi,

I want to create a list of columns to use in "column switcher", something like that.

col_list = temp_dt << Get Columns Name();

current data table (dt_main);

obj = Graph Builder(...)

Col_Switcher = obj << Column Switcher( :col1, col_list );

But it is not working...

Any ideas?

Re: create subset with list of columns

txnelson — Fri, 06 Dec 2019 03:39:37 GMT

Here is an example that works.

I assume that it will work for you, which means, if your code isn't working you need to look at your data to see what is wrong. You may want to look at the list of columns that you are getting from your dt_temp data table. Are the columns selected existing in the dt_main data table?

names default to here(1);
dt=open("$SAMPLE_DATA/Semiconductor Capability.jmp");

dtSub = dt << subset(columns({PNP1,PNP2,PNP3}));
col_List = dtsub<<get column names(continuous);

gb = dt << Graph Builder(
	Variables( X( :PNP4 ), Y( :NPN1 ) ),
	Elements( Points( X, Y, Legend( 3 ) ), Smoother( X, Y, Legend( 4 ) ) )
);
Col_Switcher = gb << Column Switcher(
		:PNP4,
		col_List
	);

topic create subset with list of columns in Discussions

create subset with list of columns

Re: create subset with list of columns