topic referencing column using Column("name") in Discussions

referencing column using Column("name")

derchieh — Fri, 09 Jun 2023 18:11:33 GMT

Hi,

I have a "quick" question:

dt = Open( "$Sample_data/Big Class.jmp" );

//// These don't work;
dt << Select where( Column("sex") == "F"); 
dt << Select where( Column(3) == "F");

//// Only this works...why??
dt << Select where (:sex == "F");

I am pretty sure all these options used to work for me.....has something changed? I am using JMP16.

Reason I am asking is because I usually have the column names in a list, then create iteration using For loop and Column(colname[i]) to point to the appropriate column.

Any help will be much appreciated. Thank you.

Derchieh

Re: referencing column using Column("name")

pmroz — Fri, 25 Feb 2022 12:42:38 GMT

This works:

dt = Open( "$Sample_data/Big Class.jmp" );

//// These work now;
dt << Select where( as Column("sex") == "F"); 
dt << Select where( as Column(3) == "F");
//// Only this works...why??
dt << Select where (:sex == "F");

In general, if column("col-name") doesn't work, try as column("col-name").

Re: referencing column using Column("name")

txnelson — Fri, 25 Feb 2022 12:46:13 GMT

You need to use the As Column() function. I tested the code back to JMP 11 and the Column() function did not work, only the As Column()

names default to here(1);
dt = Open( "$Sample_data/Big Class.jmp" );

//// These don't work;
dt << Select where( as Column("sex") == "F"); 
dt << Select where( as Column(3) == "F");
//// Only this works...why??
dt << Select where (:sex == "F");

Re: referencing column using Column("name")

derchieh — Fri, 25 Feb 2022 12:49:40 GMT

Thanks heaps for checking....!

topic referencing column using Column(&quot;name&quot;) in Discussions

referencing column using Column("name")

Re: referencing column using Column("name")

Re: referencing column using Column("name")

Re: referencing column using Column("name")

topic referencing column using Column("name") in Discussions