Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Dynamically stack input data horizontally

7 - Meteor

Problem : How to dynamically join input from different sheets horizontally. The workflow should be dynamic like when more sheets gets added to excel file the output should update accordingly.


Desired Output :



Col A and Col B are coming from Sheet 1 in excel file

Col C and Col D are coming from Sheet 2 in excel file

Col E and Col F are coming from Sheet 3 in excel file


It should be dynamic. If more sheets are added to the excel, then the first two columns of the sheets should be stacked horizontally. 

16 - Nebula
16 - Nebula

Hi @sh0kat ,


Solution attached.

I'm using the transpose and cross tab tool to create the process of column creation based on filenames




Let me know if you need further assistance.


Fernando Vizcaino

7 - Meteor

Thanks. That was way too quick.