topic How to create a workflow that can run a set of analyses for multiple files in one folder in Discussions

How to create a workflow that can run a set of analyses for multiple files in one folder

mdeng — Wed, 12 Feb 2025 18:07:02 GMT

Hi,

I would like to use a workflow to run the same set of analyses on multiple .csv files saved in a folder.

I know how to create a workflow for a specific .csv file, but I don't know how to create a workflow to run the set of analyses on a list of .csv files. My JSL skill is limited.

I appreciate your help.

Margaret

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

jthi — Wed, 12 Feb 2025 18:48:39 GMT

Workflows do have For Each (in JMP18) which you might be able to utilize

Or maybe you could add all your results into same table using Multiple File Import WITH the file name. Then perform your analysis using filename column as By column in the JMP platform.

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

mdeng — Wed, 12 Feb 2025 18:55:24 GMT

Hi Jarmo,

Can you create a simple example by showing how to use For Each? I tried it and didn't get any success.

Example:

Open two files

Create two analyses that will be performed for each file.

Thanks

Margaret

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

jthi — Wed, 12 Feb 2025 19:19:21 GMT

Open tables and group them

Run analysis on one table and group it to for each

Use group defined first as source for for each group

Seemed to work but I'm not sure if this is the way how these should be used as I don't really like using workflows

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

mdeng — Wed, 12 Feb 2025 20:15:47 GMT

Hi Jarmo,

I tried your recommendation and created the workflow above. The workflow opened all three files. Then, it stopped and asked me to select a file to run the control chart. Any other recommendations?

Thank you so much!

Margaret

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

jthi — Wed, 12 Feb 2025 20:18:19 GMT

You didn't select source for the for each (you have to tell it to use the Group you created earlier)

You can also rename the group (and you should) by changing the step name of the group

Re: How to create a workflow that can run a set of analyses for multiple files in one folder

mdeng — Wed, 12 Feb 2025 20:20:29 GMT

Yeah, it worked!

Jarmo, thank you so much! :)