input multiple sheets with different schemas and headers

[pvi]

dear community, 

may I ask for your help? 

getting really desperate from all the hours spent with try-and-error and researching. 

the task seems simple: 

have this excel file with multiple tabs that have all different headers. 

my goal is to input all the data. 

my attempt with the batch macro failed (only one record generated). 

I tried to standardise the headers by renaming them by its type. 

maybe I am on the completely wrong track with that. 

I am still learning. 

so, if you could maybe add printscreens of the solution this would be really helpful. 

thank you very much in advance for your help. 

[atcodedog05 · Accepted solution]

Hi @pvi 

I was able to build a different method to read all data from different sheets. I am converting columns to rows to maintain same shema. I am tagging sheetname and record id so it can easily be accessed.

Workflow:

Macro:

Place the files in the same folder it should work. Or use this guide to open packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Hope this helps : )

[pvi]

brilliant approach! thank you very much!