Concatenating excel files in jmp

[#1]

Hi all.

I would like to create JMP script that open specific constant folder.

In that folder, I would have many folders (each with different "Lot" name).

In each "Lot name" folder, I will have many excel files in different name and sometimes with different first sheet name.

What I want is a script that do the follow:

1. Open the specific constant folder (with constant name)
2. Open each "Lot name" folder
3. Concatenating all the excel files in that folder (only the first sheet from each excel file)
4. continue to concatenating in the same jmp file all the excel file for each Lot.

what I would have at the end is: jmp file with all the Lots excel files from the "constant folder" concatenated.

P.S: in all the excel files, I have a column with the Lot number, so when I concatenating all the excel files I will not loss the Lot number...

Is there a script that can do that for me? What do I need to do?

Thanks,

Reshef Finkelstein

[#2]

This discussion might be helpful

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

in the example the file type is CSV, but it works equally well with .xlsx files.