Import Multiple Excel sheets with different column headers

Question

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

alteryx test file.yxzp

EJ_Alt · Answer

Thanks @ChrisTX

ChrisTX · Answer

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/ta-p/20480