- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
"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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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)]);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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)]);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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