cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
ConfidenceOwl94
Level III

"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
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