Choose Language Hide Translation Bar
Highlighted
adam
Level IV

Delete columns based on empty row

Hi Guys,

 

I have a question about deleting column(s) based on empty rows. However, in my case is if 80%(can be flexibly defined) of the rows are empty, I would like to delete that particular column(s). Kindly advise how to do that. 

 

Thank you.

1 REPLY 1
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Delete columns based on empty row

Assuming you want to do this with JSL, take a look at the Col N Missing() function. It will tell you the number of missing values for a column. You can then compute the ratio against the total number of rows in the data table (N Row() function).

-Jeff
Article Labels

    There are no labels assigned to this post.