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;
I get the following error:
This is the actual script:
"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$`",
dtsplit << Select Where(Is missing(:Product) | Is missing(:weight 1) | is missing(:strength)) << Delete Rows;
Any help would be greatly appreciated, thanks in advance.
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'.