topic Re: How do I pull data from multiple CSV files? in Discussions

How do I pull data from multiple CSV files?

akeno211 — Thu, 08 Jun 2023 16:41:55 GMT

I have some CSV files with identical headers. Is there a fast way to add the data from the newer files into the JMP data set? (Faster than opening the file + copy + paste?) Something which I could save the script and just click the button every time there's a new file?

Re: How do I pull data from multiple CSV files?

SamGardner — Mon, 23 Jan 2023 20:29:47 GMT

Try the Multiple File Import (MFI). On Windows it is available under File > Import Multiple Files, on MacOS is available under File > Open Multiple. It will save a script to the data table that is generated with the MFI that you could then copy and re-use, and you can also save a script to a script window from the MFI dialog.

Re: How do I pull data from multiple CSV files?

txnelson — Mon, 23 Jan 2023 20:30:20 GMT

You can use Multiple File Import for this. Here is the entry from the Scripting Index on how to use it