How to set up data query for CSV files

[#1]

Hello everybody,

I´ve got the following situation:

I have one folder with several csv-files. Every week another csv-file is put into the folder. All the files do have the same structure.

At the moment I´m putting the data together by copy and paste into a JMP-file:

Every time a new csv-file is available, I copy the data from this file, open the JMP file and paste the new data at the end of my data table.

Are there any possibilities to automate this process in JMP?

Thanks in advance!

[#2]

This can be easily automated with some JSL. Couple of questions:

1. How automated you need this to be?
2. Can you control when the .csv file is generated?
3. Are there more than one user (you?) for the JMP file?
4. Edit: How big are the csv files? How many will there be in the end?

Based on initial information, I would add file name column to the JMP file you have, then create JSL script which would do something like:

1. Open the JMP file
2. Get list of file names already appended
3. Get all file names in the folder
4. Compare the two lists and append missing files to JMP file
5. Save and close JMP file

[#3]

Thank you for the response.

1. How automated you need this to be? > As much as possible. But it would be ok for me to do a manual step when opening the JMP file (update button or sth like this)
2. Can you control when the .csv file is generated? > no.
3. Are there more than one user (you?) for the JMP file? > At the moment its just me.
4. Edit: How big are the csv files? How many will there be in the end? > Up to 10 mb. About 100 files in the end.

Is there also a solution for this kind of issue:

I do have just one csv file in which data is written to continuously. 

PS: I do have no experience with JSL.