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.
SOLVED

Dynamically stack input data horizontally

sh0kat
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 :

shokatsaifi_0-1587644233146.png

 

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. 

2 REPLIES 2
fmvizcaino
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

fmvizcaino_0-1587645543391.png

 

 

Let me know if you need further assistance.

Best,

Fernando Vizcaino

sh0kat
7 - Meteor

Thanks. That was way too quick.

Labels