274916_en-US

liliconcom

CSV Files Join (more than 900files)

Hello

I have a question about Table Join(?) in CSV format.
There are several files in the same format as shown in the picture.

 

==============================================================================================

 

 

 

 

 

===================================================================================
I'd like to combine all the first columns with date data

(Drop if some wrong dates or times go in) with about 900 different data only after the column name and value...

What should I do?

Data TableOtherRe: CSV Files Join (more than 900files)I'd write a macro for this. Easiest way is to do the Join-command once in JMP manually, then open the "source" macro in the resulting table and add a loop around the join-command. If your files are named "File 1", "File 2" etc, it's really easy and you can run a numeric For-Loop. You can also add arguments when to drop columns or dates, and anything else you want to do at the same time for each file
Personally, I would even put the open-File command inside the loop. Meaning the macro opens one file after another (and perhaps closes it after it is joint so you don't end up with 901 open tables)
Cheers,
Kofi