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

[#1]

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

[#2]

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.

[#3]

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

[#4]

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 

[#5]

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

[#6 · Accepted solution]

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

[#7]

Yeah, it worked!

Jarmo, thank you so much!