input multiple sheets with different schemas and headers

Question

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.

4701229_0Y8QTHSX.xlsx

atcodedog05 · Accepted Answer

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/ba-p/779546

Hope this helps : )