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

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

lala — Fri, 09 Jun 2023 17:08:09 GMT

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 );

Thanks!

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

txnelson — Sat, 20 Aug 2022 13:09:16 GMT

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?

lala — Sat, 20 Aug 2022 13:24:47 GMT

Thank Jim!