Excel Combine Different Schema's into Single Excel

Question

Hi There,

Can you help? I have 3 excels with related data but different in that they all have different column numbers....

I don't want to union these excels....What i want to do is get Alteryx to combine the 3 superstore excels....Superstore A, Superstore B and Superstore C....into a single Excel called Superstore All that has the 3 Superstore A, Superstore B and Superstore C excels as separate worksheets.

What i want is attached as Superstore All

Don't need colors. I only added excel colors to help view on what needed...also all these excels will typically be in same folder directory if that helps...

superstore a.xlsx

superstore b.xlsx

superstore c.xlsx

superstore all.xlsx

superstore all pic.png

DelData · Answer

Thanks for letting me know....i will see if possible to get newer version :)

alexnajm · Answer

Ah, that version is still too old - you'll need to have 2023.1 or newer to use the Control Container functionality I am utilizing.

You can try using Block Until Done tools to ensure one part finishes before another part starts

DelData · Answer

dooh!...i am really old version Alteryx Admin Designer Version: 2021.3

I cannot open workflow due to me having older version.....I have now requested 2022.1 which will although still old is better than 2021.3

Once i have new 2022.1 installed I will try to open workflow...thanks for taking time out to help :)