cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

'nresolved Column error on JMP 18

I am getting a 'Unresolved Column' JMP Alert when trying to automate the concatenation of two data-tables. It works completely when I concatenate them manually. I thought maybe something weird was happening with the datatype (even though they are the same when checking) so you can see I have force added them to be the same datatype. 

I have this sort of 'master' script in MATLAB that I have this whole script embedded in. I call the JMP executable to open and run this script which I thought could attribute to the problem but in the MATLAB portion It is able to successfully run a JSL script previously (and I close that instance of JMP after and re-open it for this one). 

The JMP Alert causes the rest of my MATLAB script to hang as it's waiting for this script to finish.

Any help will be appreciated. 

// open newly generated ADTDatapoolTable.jmp
dtGenerated = Open("C:\Users\fnunziato\Downloads\ADTDatapoolTable.jmp");

// Step 1: Open ADTDatapoolTestWColumnsRenamed.jmp (Target Table)
dtTarget = Open("C:\Users\fnunziato\Downloads\JMPTest\ADT DatapoolTestWColumnsRenamed.jmp");

// Step 2: Concatenate dtGenerated into dtTarget (Append to first table)
Column(dtGenerated, "Mass Fe (g)") << Set Data Type(Numeric);
Column(dtTarget, "Mass Fe (g)") << Set Data Type(Numeric);
dtTarget << Concatenate(
    Data Table(dtGenerated),
    Append to First Table(1)
);

// Step 3: Run the Summary Script found on dtTarget
dtTarget << Run Script("Summary Script");

// Optional: Close all tables to clean up
dtGenerated << Close(NoSave);
dtTarget << Close(Save);

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: 'nresolved Column error on JMP 18

Are you sure you are getting the error from concatenate part? I'm not sure if these changes will solve the issue (remove datatable from concatenate and use close() instead of << close)

Names Default To Here(1);

dtGenerated = Open("C:\Users\fnunziato\Downloads\ADTDatapoolTable.jmp");

dtTarget = Open("C:\Users\fnunziato\Downloads\JMPTest\ADT DatapoolTestWColumnsRenamed.jmp");

Column(dtGenerated, "Mass Fe (g)") << Set Data Type(Numeric);
Column(dtTarget, "Mass Fe (g)") << Set Data Type(Numeric);
dtTarget << Concatenate(
    dtGenerated,
    Append to First Table(1)
);

dtTarget << Run Script("Summary Script");

Close(dtGenerated, no save);
Close(dtTarget, no save);
-Jarmo

View solution in original post

5 REPLIES 5

Re: 'nresolved Column error on JMP 18

I guess it's also worth to note that upon checking the output of the script, it seems to do it's job and concatenate them just fine and there is nothing visually abnormal to me. It is just the error that is my issue since it hangs the rest of my script.

jthi
Super User

Re: 'nresolved Column error on JMP 18

Are you sure you are getting the error from concatenate part? I'm not sure if these changes will solve the issue (remove datatable from concatenate and use close() instead of << close)

Names Default To Here(1);

dtGenerated = Open("C:\Users\fnunziato\Downloads\ADTDatapoolTable.jmp");

dtTarget = Open("C:\Users\fnunziato\Downloads\JMPTest\ADT DatapoolTestWColumnsRenamed.jmp");

Column(dtGenerated, "Mass Fe (g)") << Set Data Type(Numeric);
Column(dtTarget, "Mass Fe (g)") << Set Data Type(Numeric);
dtTarget << Concatenate(
    dtGenerated,
    Append to First Table(1)
);

dtTarget << Run Script("Summary Script");

Close(dtGenerated, no save);
Close(dtTarget, no save);
-Jarmo

Re: 'nresolved Column error on JMP 18

You were right on the first part, I removed the last part of the JSL script after the concatenation and I do not get the error. Seems the error is generated from the dtTarget << Run Script("Summary Script"); line. (The script when ran manually works fine so I've been running through some debugging to figure out what's going wrong there). Thank you for bringing that up that it may not be from the concatenate part (I assumed so since it was a column error). Going to accept this as the solution since the original ask was for an error from concatenation.

jthi
Super User

Re: 'nresolved Column error on JMP 18

Depending on the script, there could be a difference in "current data table()" or something similar.

-Jarmo
hogi
Level XII

Re: 'nresolved Column error on JMP 18

run script and current data table?
JMP need some while to switch the current data table to the right table

->> maybe it helps to add a  wait()at the top of the table script.

 

https://community.jmp.com/t5/Discussions/ThisDataTable/m-p/766181/highlight/true#M94617