Dynamic input and directory tool to read different file formats

Question

Hey,

I am dealing with 6 input files almost all of which have different format.

3 are xlsx format. 2 are csv but 1 with comma as delimiter while other with tab as delimiter. And 1 is fixed width file format.

I have created all processes corresponding to different inputs using normal input data tool and corresponding configurations.

But want to combine all this using directory tool, filter, formula, and dynamic input tool to pick all formats input (Like it is done in xlsx format files)

Is it possible to combine different file formats using dynamic input keeping the same configuration I selected in normal data input tool? And if not what is the workaround for that...

Thanks

binu_acs · Answer

@apathetichell Yes I did 😀. I prefer batch macro over dynamic input tool

apathetichell · Answer

This isn't a Dynamic Input project - it's a batch macro project - check out this weekly challenge.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

@binu_acs- do you ever scratch your head why people love Dynamic Input so much?

ShantanuDagar · Answer

Not same to each other. But remains same for 1 input file across every run.