How can I use a dynamic column name?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!
Re: How can I use a dynamic column name?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
)