535717_en-US

liliconcom

How do know if the list of column names in a data table contains a variable?

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
cNa = dt << get column names;
xF = As List( cNa[2 :: N Col( dt )] );//Eval(xF)

tt = "age";
s = Contains( xF, tt );<BR />

 

Thanks!

ScriptingRe: How do know if the list of column names in a data table contains a variable?

Here is the definitive check that I use

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
cNa = dt << get column names;
xF = As List( cNa[2 :: N Col( dt )] );//Eval(xF)

tt = xF[1];
s = Try( Length( as Column( dt, tt ) << get name ), 0 ) > 0;

 

Re: How do know if the list of column names in a data table contains a variable?

Thank Jim!