How to combine 400 workflows into one data set

I have 400 identical workflows (one workflow per quarter), and I need to aggregate the data from all of them in one excel spreadsheet. How to connect each workflow with "Union" icon without drawing lines connecting every workflow with "Union" icon? Thank you!

Dynamic Processing

Accepted answers

All comments

morr-co

Hi @MariaSmor : can you clarify what you mean by 400 workflows? What is the input for your workflows? Is it a data file? If so, you could use a Batch Macro to read all of the inputs (files) and combine them into a common output.

Qiu

@MariaSmor
If the workflow are really "identical" except for input, then instead of 400 flows, maybe a batch marco can do the same.

Then the output of macro can be a union.

MariaSmor

Hi! The input for a workflow is an excel spreadsheet. I collect certain data from a spreadsheet (80 fields) and I have already collected data form 400 files. I need to use "Union" icon to combine data form each of the workflow, but then I need to create a link between each workflow and "Union" icon 400 times.

MariaSmor

Thank you! I'll try to learn about batch macro.

aghani006

Agree with others. Its better to use batch macros with conditions.

hroderick

write out to 400 files with different names into the same directory then use dynamic input tool to combine

grazitti_sapna

Hi @MariaSmor , if you are just looking to connect your workflows to a union tool and make the connections wireless it can be done you just need to connect the workflows one time to union tool and then right click on the union tool and select make connection wireless. Please refer to the sample screenshot if it helps.

Thanks.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235