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; } } }

How can I judge value cell and modify it in JMP script?

unknown

Sorry! I’m a beginner in JSL.

I want to judge value of cell it will be deleted if it was not I want in cell.

Such as : if( {column[4] ,row[5]} =1 , column[4],row[5]->will be deleted) ,

How can I do?

Accepted answers

pmroz

Chris,

If you want to test a cell value and then delete the cell value you can use something like this:

dt = current data table();

for (i = 1, i <= nrows(dt), i++, // Loop over all column 4 values
if (column(4)[i] == 1,

// then

column(4)[i] = .; // Numeric "null"

);

All comments

wiebepo

There are a number of ways to use criteria to delete rows. Here is a solution to the example shown:

::data_table=currentdatatable();

If(column(::data_table,4)[5]==1, ::data_table<<deleterows(5));

pmroz

Chris,

If you want to test a cell value and then delete the cell value you can use something like this:

dt = current data table();

for (i = 1, i <= nrows(dt), i++, // Loop over all column 4 values
if (column(4)[i] == 1,

// then

column(4)[i] = .; // Numeric "null"

);

gbu

Maybe something like this :

RowsToDelete = dt << Get Rows Where(:COLUMN_NAME = 4);

dt << Delete Rows(RowsToDelete);

Regards,

Guillaume

unknown

Thank you for your answer

You help me solve a knotty trouble.