Beginner JSL scripter here...
I want to create a script that will delete any rows that have missing data within any column. Right now if I rename the column(s) it will work like this:
clean_dt << selectWhere(IsMissing(:THK)) << deleteRows ;
The problem is, I want this script to be dynamic and be able to handle any name for any column that I give it and reference it by column number for example. Lets say the column name is complex like this
Step::Measurement::Data::THK:Raw (Mean)
I dont want to have to rename my columns everytime... I've tried several iterations of things that I think "should" work, but they dont such as
clean_dt << selectWhere(IsMissing(Column(8))) << deleteRows ;
OR
clean_dt << selectWhere(IsMissing(:Step::Data::THK:Raw (Mean))) << deleteRows ; (column name is too complex with special characters)
Each time it errors with this message
argument should be numeric{1} in access or evaluation of 'Is Missing' , Is Missing/*###*/(Column( 8 ))