File Union for files with different data structure

[rajat_del]

Hi All,

I have 10 files all basically same but with some extra columns. All the files are named differently and even the sheets are named differently.

I want to make one big file from those rather than using 10 input tools to read each one. The extra columns should come at last sort of like union tool.

Is there any way to do it? I tried it with directory and dynamic input, tried with the wild character in input tool but i can't seem to pull it off.

[binuacs]

@rajat_del use a batch macro to solve your problem

 https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...