Pretty new to scripting and need a bit of help (as a chemist self trained in JmP),

chrisnally0

I am looking to remove rows where there are missing data points (ie row 94 below); have done previous searches on this issue and tried the fix below:

dtsplit << Select Where(Is missing(Pr) | Is missing(:weight 1) | is missing(:Strength)) << Delete Rows;

I get the following error:

This is the actual script:

dt=

Open Database(

"DSN=Excel Files;DBQ=P:\INKJETS\MDU\Chris\JMP TRIAL.xlsx;DefaultDir=P:\INKJETS\MDU\Chris;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;",

"SELECT * FROM `Sheet1$`",

"Sheet1$"

);

dtsplit << Select Where(Is missing(:Product) | Is missing(:weight 1) | is missing(:strength)) << Delete Rows;

Any help would be greatly appreciated, thanks in advance.

ian_jmp

The error occurs because although you are using it as a reference to a table when you try to send messages to it with '<<", you haven't told JMP which table. Try changing the first 'dt' (the result of 'Open Database()') to 'dtsplit'.