topic How to set up data query for CSV files in Discussions

How to set up data query for CSV files

JohannesENS — Sat, 10 Jun 2023 23:47:39 GMT

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!

jthi — Wed, 27 Apr 2022 13:27:49 GMT

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

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:

JohannesENS — Thu, 28 Apr 2022 06:25:35 GMT

Thank you for the response.

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)
Can you control when the .csv file is generated? > no.
Are there more than one user (you?) for the JMP file? > At the moment its just me.
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.