Dynamic input and directory tool to read different file formats

[ShantanuDagar]

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]

@ShantanuDagar Are the 3 .xlsx files and 2 .csv having the same schema? 

[ShantanuDagar]

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

[apathetichell]

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?

[binu_acs]

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