Choose Language Hide Translation Bar
Highlighted
Theresa
Level III

How to realize search 3 column, if there is any column>100, then add new column fill in with "1"

How to realize search 3 columns in the table, and if column "age, height,  weight" any row value in same column value>100, then add new column name "Mark" fill in with "1", others NA.

 

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

Final result i want:

Theresa_0-1584314578574.png

 

1 REPLY 1
Highlighted
txnelson
Super User

Re: How to realize search 3 column, if there is any column>100, then add new column fill in with "1"

It is a simple script to handle what you want.  Here is a formula to that can be specified for your column called Mark

If(:age > 100 | :Height >100 | :Weight > 100, 1, .)
Jim
Article Labels

    There are no labels assigned to this post.