328775_en-US

liliconcom

How can get matching data directly from memory variables？

How can get name="JOHN" matching "height" data directly from memory variables"

Thanks!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
na="JOHN";//How can get matching "height" data directly from memory variables
hei=Update(With(dt),Match Columns(:name=na),Add Columns from Update table(:height));

 

ScriptingRe: How can get matching data directly from memory variables？

Here is one method

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

vals=Associative Array(dt:name,dt:height);

hei=vals<<GETVALUE></GETVALUE>

Re: How can get matching data directly from memory variables？

The original method:

 

r = Contains( :name[Index( 1, N Row( dt ) )], na );
hei = dt[r, "height"];