Unresolved Column at Row 1 Error

BenWard — Thu, 08 Jun 2023 16:39:54 GMT

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;

Re: Unresolved Column at Row 1 Error

Thierry_S — Mon, 30 Jan 2023 12:56:35 GMT

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,

Re: Unresolved Column at Row 1 Error

BenWard — Tue, 31 Jan 2023 12:05:07 GMT

Thank you, all fixed now!

topic Re: Unresolved Column at Row 1 Error in Discussions

Unresolved Column at Row 1 Error

Re: Unresolved Column at Row 1 Error

Re: Unresolved Column at Row 1 Error