cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
mmaranta
Level I

Scripts that pull Excel columns not stacking properly in JMP 18 vs. JMP 17

Hello.  I have a script that takes input from Excel files and stacks data, etc.  I've attached a small sample of the script along with a sample excel file, in 17 the end product is two columns (the desired output) but in JMP 18 extra columns are generated and my very involved scripts than do not load/label data properly.  I get the following error in 18:

 

at line 50 in Z:\Data\Michelle\Automation\Scripts\JSL Control Scripts\test script.jsl

2 REPLIES 2
jthi
Super User

Re: Scripts that pull Excel columns not stacking properly in JMP 18 vs. JMP 17

Does the first table look same? If it does, you might have to make small changes to the settings, such as dropping all extra columns (it defaults to keep)

jthi_0-1743193230713.png

 

-Jarmo
mmaranta
Level I

Re: Scripts that pull Excel columns not stacking properly in JMP 18 vs. JMP 17

Both JMP 17 and 18 have Keep All as default, but does give me some ideas to investigate.  Thanks for looking at this.

 

Recommended Articles