cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lala
Level VIII

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

 

Thanks!

2022-08-20_18-39-30.png

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: 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;

 

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: 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;

 

Jim
lala
Level VIII

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

Thank Jim!2022-08-20_21-23-16.png