cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.

Discussions

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

JMP import Excel from columns that are not continuous

My example here is: I have an excel table currently with 50 columns and is continuously growing. I only want to import first 4 column and last 5 column at any time. How do I achieve that with JMP script.

1 REPLY 1
txnelson
Super User

Re: JMP import Excel from columns that are not continuous

I am not aware of being able to input just a specified list of columns from an Excel spreadsheet. (but I am not an Excel expert).  However, if you place this JSL as the first statements after reading in the spreadsheet it will delete the unwanted columns.

Names Default To Here( 1 );
dt = Current Data Table();
dt << delete columns(index(5,ncols(dt)-5));

 

Jim

Recommended Articles