Merging multiple excel sheet with different schema

[hiteshnpwc]

Hello Everyone,

I am trying to merge the same Excel file with multiple Excel sheets with Different schema. I used the dynamic input tool to merge, however, due to a different schema it is getting failed. Data should be merged under a single header and different columns should be added in the sheet with null values if they are missing in other data.

Need your advice to complete this.

Thanks in advance. Attached is the sample data.

[messi007]

@hiteshnpwc,

Please take a look on this post : https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo... 

Hope this helps!

Regards

[ed_hayter]

Hopefully this works - although I expect given the structure of your headers it will perhaps need more prep work?