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.
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).