cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar

JMP importing change since 18 upgrade

My scripts that I made before using the "Open" command is JSL is now way too slow. My script takes 12 minutes to execute now.

How should I import excel sheets now or please fix this but in JMP 

 

I used to import my excel files using this code below but it takes too long:

 

Open(
"/Z:/Shared/R&D/Runsheet.xlsx",
Worksheets(
{"Thickness"}
),
Use for all sheets( 1 ),
Concatenate Worksheets( 1 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 2 ),
Data Starts on Row( 3 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 33 ),
Replicated Spanned Rows( 1 ),
Replicated Spanned Headers( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 1 ),
Treat as Hierarchy( 0 ),
Multiple Series Stack( 0 ),
Import Cell Colors( 0 ),
Limit Column Detect( 0 ),
Column Separator String( "-" )
)
);

dt1 = Current Data Table();
dt1 << Set Name( "Thickness");



// I do this for a few different tables and then combine the tables together using the code below. What is taking so long to run this code?



Data Table( "Thickness" ) << Join(
With( Data Table( "dt2" ) ),
Merge Same Name Columns,
Match Flag( 0 ),
By Matching Columns( :Run # = :Run #),
Drop multiples( 0, 0 ),
Include Nonmatches( 1, 1 ),
Preserve main table order( 1 ),
Output Table( "OutputTable" )
);

3 REPLIES 3
Byron_JMP
Staff

Re: JMP importing change since 18 upgrade

I've been using the same open for Excel and haven't noticed any changes. I'm opening about 100 files and concatinating them.   If you move/copy your excel files to your computer (local drive)  and then run the script is it still slow?  

 

JMP Systems Engineer, Health and Life Sciences (Pharma)

Re: JMP importing change since 18 upgrade

Yup, I just tried that and I have the same long delay (11 min instead of 12 this time) when I moved it to the C:\drive\.

 

I then tried to see if the problem is the importing of the table or the joining of the tables by importing just one table (or more specifically one worksheet of one excel file), and it still took 3 min which is better, but still way longer than it used to using JMP 17.

 

The table does have 2k rows and 33 columns. Is there a faster way to import large tables?

 

Did your 100 files contain large tables?

hogi
Level XII

Re: JMP importing change since 18 upgrade

Once I had a speed issue when importing an excel file.
I found out that some cells were combined. removing such cells increased the speed by several orders of magnitude.

But I cannot remember if the issue was with JMP17 or JMP18.