Concatenating excel files in jmp

resheffink — Sat, 10 Jun 2023 23:57:56 GMT

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:

Open the specific constant folder (with constant name)
Open each "Lot name" folder
Concatenating all the excel files in that folder (only the first sheet from each excel file)
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

Re: Concatenating excel files in jmp

Byron_JMP — Tue, 06 Dec 2022 14:15:36 GMT

This discussion might be helpful

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