Remove rows with one or more empty values using JSL

[#1]

I have a table where each row contains a single measurement type at three temperatures, each stored in its own column. Ultimately, I want to calculate the deltas between these measurements and then stack that data into a new table. However, not all measurements are taken at all three temperatures, and I need to exclude those measurements (rows) where one or more of the data columns are empty. I need to do this using a JMP 9.0 script.

Given:

dtSplit =

Measurement	T1	T2	T3
Measurement A	5	12	89
Measurement B	13		8
Measurement C		52	57
Measurement D	22	21
Measurement E	8
Measurement F			15
Measurement G		54

I need to produce:

dtClean =

Measurement	T1	T2	T3
Measurement A	5	12	89

I was trying to use something like:

dtSplit << Select Where(
     Is Empty(:T1) ||
     Is Empty(:T2) ||
     is Empty(:T3)
) << Delete Rows;

However, any Select Where(Is Empty(:COL)) always selects all rows.

I'm sure I am missing something simple, your help is greatly appreciated, thanks,

- Matt

[#2]

You need to look into the Missing Data Pattern platform.  It will allow you to identify all of the rows that have all missing values, and then you can choose to delete the rows, etc.

      Tables==>Missing Data Pattern

[#3]

Hi

Thanks for the input. Checked out the Missing  Data Pattern you recommended and it sort of works but not fully. 

In my data table, each name has 4 different rows. Each of the 4 row of a name is a result of 1 test (sens, mask, EVM and power)

In my data table example, device A fails the first test "Sens" and passes the 2nd, 3rd and 4th test. Because device A fails "Sens", this is a fail device even though it passes the 2nd, 3rd and 4th test. 

If I use Tables==>Missing Data Pattern, then 2nd, 3rd and 4th rows of A will be deleted. Which is not what I am looking for. I want to delete 4 rows of each name when there are no data on them ( no data on 10 MHz, 20 MHz, 30 MHz and 1000 MHz). In my data table, names C, G, H, I, J K and N will be deleted.

Thanks for your helps