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
Check out this Knowledge Base article.
The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
Thanks @ChrisTX