319870_en-US

liliconcom

How to use 'IF' statements to delete the entire 'Row'?How to delete the entire 'Row' when the cell is blank/empty ?ScriptingRe: How to use 'IF' statements to delete the entire 'Row'?This is an example of the a data table to my problem Operation Product Link Quantity 1 A ABC 1000 1 A ABC 3000 1 A 1350 1 A 1235Re: How to use 'IF' statements to delete the entire 'Row'?

There is no need to use an IF() clause in the deleting of the rows with missing values.

// If checking for a character column
dt << delete rows(dt<<GET rows="" where=""></GET>

Re: How to use 'IF' statements to delete the entire 'Row'?

YEAH, I agree with @txnelson , if you really wanna do this by using if, you can do like below

Names Default To Here( 1 );
dt = Open( "$sample_data/big class.jmp" );

total_rows = N Row( dt );

For( i = total_rows, i >= 1, i--,
 If( :age[i] == 14,
  dt << delete rows( i );
  wait(0.5) // wait for a while to let you see the delete action
 )
);