cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
mmaranta
mmaranta
Level I

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

Mar 28, 2025 04:08 PM (538 views)

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

test script.jsl
27 KB
0 Kudos
2 REPLIES 2
jthi
Super User jthi
Super User

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

Mar 28, 2025 04:20 PM (534 views)  |  Posted in reply to message from mmaranta 03-28-2025

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
0 Kudos
mmaranta
mmaranta
Level I

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

Mar 28, 2025 04:43 PM (529 views)  |  Posted in reply to message from jthi 03-28-2025

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

 

0 Kudos

Recommended Articles