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？

The original method:

 

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