topic Re: How to remove empty rows when importing excel in JMP in Discussions

How to remove empty rows when importing excel in JMP

HSS — Sat, 10 Jun 2023 20:48:03 GMT

Hi All,

I am importing an excel file to JMP. There are many empty rows in excel (I can not delete them manually as there are 10s of such excel files) and when I import them to JMP, I do not find any option to delete/remove/suppress these empty files. JMP do show option to suppress empty columns but nothing for empty rows (at least I couldn't find it).

I tried to put "Suppress Empty Rows( 1 )" in the code but obviously it did not work.

Or is there any other way to delete/remove entire row in JSL, if all the columns values are missing for that row. It should work irrespective of number of columns or column type.

Any help ?

Re: How to remove empty rows when importing excel in JMP

txnelson — Wed, 08 Dec 2021 22:23:14 GMT

Look into

Tables=>Missing Data Pattern

Re: How to remove empty rows when importing excel in JMP

HSS — Tue, 14 Dec 2021 12:35:05 GMT

I was not able to get the results using "Missing Data Pattern". Created a for loop on all the columns for missing values, which worked but may not the best way to deal it.
Thanks for your suggestion.