cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

"Import Multiple files" function with different column numbers

ConfidenceOwl94
Level III

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
ConfidenceOwl94
Level III


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