nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get Rows Where command only works on a specific column

Kerouwhack

Hello,

I'm using the "get rows where" command to replace numerical values with a "P" or "N" depending on whether they hit a threshold value.

Here's the code:

dt = Open( "C:\test_data.jmp" );
thresh = 12; //User sets this threshold value

Try( dt:HOOK[dt << get rows where( :Hook >= thresh )] = "P" );
Try( dt:HOOK[dt << get rows where( :Hook == "" )] = "N" );

So this works well and populates the column with N's and P's. If I copy and paste those two try lines and change the column designation it won't work on the other columns. If I change the order of the commands or change the order of the columns, it still only does the Hook column.

What am I missing?

Thanks!

Accepted answers

All comments

txnelson

Can you show us the lines after you cut and paste and change the Hook value?

My guess is that you are not changing one of the 2 places in both columns where Hook appears.

Kerouwhack

I wish it were *that* simple. The additional code is below. Is there some sort of file operator I'm missing-- like you need to close or save after each column substitution?

Names Default To Here( 1 );

dt = Open( "C:\test_data.jmp" );

thresh = 12; //User sets this threshold value (defines rows in output)

Try( dt:HOOK[dt << get rows where( :Hook >= thresh )] = "P" );

Try( dt:HOOK[dt << get rows where( :Hook == "" )] = "N" );

Try( dt:ROUNDS[dt << get rows where( :Rounds >= thresh )] = "P");

Try( dt:ROUNDS[dt << get rows where( :Rounds == "")] = "N");

Try( dt:WHIP[dt << get rows where( :Whip >= thresh )] = "P");

Try( dt:WHIP[dt << get rows where( :Whip == "")] = "N");

txnelson

There is an issue with your columns being either numeric or character. All cells in a column must be either character or numeric. In your code, you are asking column Hook to be compared with a numeric value of "Thresh". "Thresh" has a numeric value of 12. You then want to set the value of Hook to either a character "P" or "N"..

Are the columns Hook, Rounds and Whip numeric or character?

Kerouwhack

I actually considered that as well (my trouble-shooting is not too shabby for a newbie), but when I looked at column info, all three columns are set as "Numeric" & "Continuous."