How can I use a dynamic column name?

CAPEGA

How can I use a dynamic column name like this

 

 

 dt_tansposed = dt << Split(
Split By( :description ),
Split( Column Name(Value)), //??? Split(:VALUE) or Split(:AVG) works
Group( :Time ),
Remaining Columns( Drop All ),
Sort by Column Property
);

Thank you!

 

HadleyMyers

Hi,

 

Try using Column(Value), instead of Column Name (Value).  See below:

dt=Open("$SAMPLE_DATA/Big Class.jmp");

Splitcolname="height";
dt << Split(
	Split By( :age ),
	Split( Column(Splitcolname) ),
	Group( :sex ),
	Remaining Columns( Drop All ),
	Sort by Column Property
)