Import Multiple Excel sheets with different column headers

[EJ_Alt]

HI All

I am trying to figure out an elegant way, probably using the dynamic input tool (or better) to import an excel file with multiple sheets, the column headers need to be renamed too.as they are different e,g,

Bank Transfer files showing deposits with 3 banks

rename columns to this

final output

[ChrisTX]

Check out this Knowledge Base article.

The Ultimate Input Data Flowchart

Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[EJ_Alt]

Thanks @ChrisTX