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).
![Hari_0-1638979652992.png Hari_0-1638979652992.png](https://community.jmp.com/t5/image/serverpage/image-id/38229iCE260DF677938A01/image-size/medium?v=v2&px=400)
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 ?