topic Re: "Import Multiple files" function with different column numbers in Discussions

"Import Multiple files" function with different column numbers

ConfidenceOwl94 — Tue, 15 Oct 2024 15:24:16 GMT

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.

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

txnelson — Tue, 15 Oct 2024 15:47:52 GMT

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)]);

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

ConfidenceOwl94 — Tue, 15 Oct 2024 16:08:05 GMT

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