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.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

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

"Import Multiple files" function with different column numbers

I am using "Import Multiple files" function to combine multiple .CSV file in to JMP table. As Some of my files has different number of columns it is opening individuals JMP table, not combine. How can I merge multiple .CSV file with different number of column. 

 

This is a simplified data I have. First few columns are time and serial numbers but after that i have repeated measurement of the SN. No of data point collected can be different on each SN. 

 

ConfidenceOwl94_0-1729005735113.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: "Import Multiple files" function with different column numbers

You can use MFI and then as shown in the below script, you can get the list of tables produced and then concatenate them all together.

Names Default To Here( 1 );

mfi = Multiple File Import();
mfi << Set Folder( "$SAMPLE_IMPORT_DATA" );
mfi << Set Name Filter( "*.txt" );
mfi << Set Name Enable( 1 );
tables = mfi << Import Data();
dt=new table("Final");
dt << concatenate(tables[1::nitems(tables)]);
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: "Import Multiple files" function with different column numbers

You can use MFI and then as shown in the below script, you can get the list of tables produced and then concatenate them all together.

Names Default To Here( 1 );

mfi = Multiple File Import();
mfi << Set Folder( "$SAMPLE_IMPORT_DATA" );
mfi << Set Name Filter( "*.txt" );
mfi << Set Name Enable( 1 );
tables = mfi << Import Data();
dt=new table("Final");
dt << concatenate(tables[1::nitems(tables)]);
Jim

Re: "Import Multiple files" function with different column numbers

Thanks you so much,

 

I also found another article on this.

https://community.jmp.com/t5/JMP-Scripts/Combine-multiple-txt-or-csv-files/ta-p/24083

Recommended Articles