topic Re: Delete selected data in the cell in Discussions

Delete selected data in the cell

Dennisbur — Thu, 08 Jun 2023 16:34:29 GMT

Hello

I have table and I would like to delete specific data in cell.

for example with this condition as well:

1) if CORNER = VMAX

2) if MODUL = IIH

3) if PARAMETR = GPIO & MIPI

4) if LO_LIMIT is not 0

Delete the data of LO_LIMIT for these criteria

at the end I would like to receive data table

can you assist me in JSL script for this task?

Re: Delete selected data in the cell

jthi — Tue, 21 Feb 2023 09:45:26 GMT

Build your condition statements and combine them with and/or. Then get rows of interest and use that to clear rows. Below are few a bit different options

Names Default To Here(1);

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

//option1
rows_to_set_missing = dt << Get Rows Where(:age >= 13 & :sex == "F" &  :weight < 100);
If(N Rows(rows_to_set_missing) > 0,
	dt[rows_to_set_missing, "weight"] = .;
);	

stop();
// option2
Column(dt, "weight") << Set Each Value(
	If(:age >= 13 & :sex == "F" &  :weight < 100,
		.
	,
		:weight
	);
);