I need to group columns using contain function of column name.
I am trying to group a Column by a contain function of column name. I need to group every column that contain "ID". Here is what I came up with. What am I doing wrong?
<JSL>
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Air Traffic.jmp" );
Data Table( "Air Traffic" ):Event << Set Name( "ID" );
col = dt << get column names( "String");
nc = N Items( col );
colList = {};
For( i = 1, i <...