BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
BSwid

Contributor

Joined:

Sep 25, 2018

JMP Excel File Import - Can I ignore columns in the Excel file?

Either in the import wizard or in the import script (data source script) can I write script that ignores certain columns so that it is not imported from the source file to the JMP file?

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: JMP Excel File Import - Can I ignore columns in the Excel file?

This is all found in the Scripting Index....description and examples

     Help==>Scripting Index........search on "delete columns"

delete columns.PNG

Jim
3 REPLIES 3
msharp

Super User

Joined:

Jul 28, 2015

Re: JMP Excel File Import - Can I ignore columns in the Excel file?

No, and you wouldn't want to.  It may be unintuitive but it will be faster to just import the entire .csv file and then delete the extra columns via dt << Delect Columns(ListOfColumns).  CSV importers are heavily optimized for reading the data, they aren't built for data clean up which would come at the cost of too much overhead.

BSwid

Contributor

Joined:

Sep 25, 2018

Re: JMP Excel File Import - Can I ignore columns in the Excel file?

Thank you.  So in summary, import all, then add to the script the delete columns syntax.  Could you please point me ot the syntax in JSL to delete multiple columns?  

txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: JMP Excel File Import - Can I ignore columns in the Excel file?

This is all found in the Scripting Index....description and examples

     Help==>Scripting Index........search on "delete columns"

delete columns.PNG

Jim