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

[#1]

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?

[#2]

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.

[#3]

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?  

[#4 · Accepted solution]

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

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

delete columns.PNG