Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
The Community search bar will be undergoing a scheduled upgrade on January 30th between 4:30-6:30a EST. Please utilize your browser's search during this time. Thank you for your patience!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor
17 - Castor

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
Top Solution Authors