Join multiple tabs

[lucyduomon]

Hi all, 

I have a file with multiple tabs (too many for manual inputs), which all have the same schema. I would like join all the tabs, which means combining tabs as separate columns and not rows. I have tried the dynamic input and batch macro, and got to a point that I can stack together all the tabs, but that's different from what I wanted. 

Any advice or point of direction would be helpful. Thanks!

[AkimasaKajitani · Accepted solution]

What you want to do is concatenate Excel sheets horizontally?

Input

Sheet1

A	B
13	16
14	17
15	18

Sheet2

A	B
7	10
8	11
9	12

Sheet3

A	B
1	4
2	5
3	6

Output

A_Sheet1	A_Sheet2	A_Sheet3	B_Sheet1	B_Sheet2	B_Sheet3
13	7	1	16	10	4
14	8	2	17	11	5
15	9	3	18	12	6

I make the below workflow.

Please see attached file.

[joshuaburkhow]

This is currently how to do it. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Joining-multiple-excel-worksheets/m-p/...