cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
BenWard
Level I

Unresolved Column at Row 1 Error

Hello, 

 

I am new to JMP and have been tasked with generating a control chart. One of the tasks for this is to write scripts that will exclude certain values etc. My issue is a little strange and I can't seem to find a fix for it even after scanning this discussion page. Basically, everytime I go to run my script (attached below) I am met with the error 'Unresolved Column at Row 1'. However, if I open the script, go to the end, press the spacebar and then backspace, and run again, it all works perfectly. Would anyone happen to know how to fix this issue? It's driving me a bit insane. Thanks for the help!

 

To note, I have tried changing that first line of script to 

dt1 = Current Data Table();

and

current data table( dt1 );

but I receive the same error with both of these as well. 

 

dt1 = Data Table( "JMP TRENDING_BW control chart analysis" );
dt1 << select where( :"Reference ND50" > 59160
	| :"Reference ND50" < 70.4
	| : "VOC Average pfu/well" > 4320
	| : "VOC Average pfu/well" < 5.5
);
dt1 << hide and exclude;
2 REPLIES 2
Thierry_S
Super User

Re: Unresolved Column at Row 1 Error

Hi,

You may have a minor syntax issue concerning the column calls. The correct syntax is

:"Reference ND50"n

 

(note the "n" to specify that you are using a string as a column name.

 

Let us know if that fixes your script.

 

Best,

TS

Thierry R. Sornasse
BenWard
Level I

Re: Unresolved Column at Row 1 Error

Thank you, all fixed now!