How to Manipulate Input Files the same way?

[jonnyrask]

I have many files and I want to manipulate the files the same way. This is what I want to do, but the dynamic input tool combines the files instead of just allowing me to apply the union to each specific file it applies to all of them.

I guess my questions is: How can I apply the same tools to an unknown number of different files without having to do an input file for each and every one of them?

Thanks!

[AbhilashR · Accepted solution]

Hi @jonnyrask, to help us better understand your challenge, are you looking to read multiple excel files from a given folder using one input tool (or dynamic input tool)?  If yes, then the following Community article might be a good starting point to learn more about how one should think about their solution. I have attached a sample workflow that is built along the same lines to help you get started.

[randreag]

Hi @jonnyrask 

I understand you need to apply a union to many files.

You can do it creating a simple macro . I attached an example.

The advantage in comparison with the dynamic input is that you are not going to have errors with the differences in fields.

The input in my example are paths but can come from a Directory tool too 

Regards