BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
chrisnally0
Community Member

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

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.

0 Kudos
1 REPLY 1
ian_jmp
Staff

Re: Pretty new to scripting and need a bit of help (as a chemist self trained in 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'.

0 Kudos