Subscribe Bookmark RSS Feed

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

chrisnally0

Community Member

Joined:

Feb 5, 2016

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;

10915_pastedImage_2.png

I get the following error:

10919_pastedImage_3.png

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.

1 REPLY
ian_jmp

Staff

Joined:

Jun 23, 2011

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