Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

input multiple sheets with different schemas and headers

pvi
6 - Meteoroid

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. 

 

pvi_0-1626850119534.png

 

pvi_1-1626850125974.png

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

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:

atcodedog05_0-1626851951627.png

Macro:

atcodedog05_1-1626851969421.png

 

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
6 - Meteoroid

brilliant approach! thank you very much!

Labels