Alteryx Designer Desktop Discussions

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

Designer| Union multiple datasets into one excel tab

Mj9715
8 - Asteroid

Hi All, 

 

I have five different output results generated from workflows and a disclaimer text that needs to be combined into one output and write out to an excel sheet tab. 

 

For convenience, I have given the workflow outputs which need to be joined together as Input 1-5 in different tabs of attached excel. The final output has these datasets joined one below the other with spaces in between each dataset. This is shown in the "Final output" tab of attached excel. 

 

Keeping in mind that I have Alteryx 2019.4, can someone please guide if this is possible?

 

Input example 1

2 Year Cumulative0.6125380.073604
3 Year Cumulative0.0470210.352199
5 Year Cumulative0.4578310.711525
10 Year Cumulative0.8812230.188912
From 31/12/99 Cumulative0.8752220.307666

 

Input Example 2 

2 Year Annualised4.533.468442
3 Year Annualised6.315.573498
5 Year Annualised3.863.235162
10 Year Annualised6.906.21913
From 31/12/99 Annualised6.115.901789

 

Output 

2 Year Cumulative0.6125380.073604
3 Year Cumulative0.0470210.352199
5 Year Cumulative0.4578310.711525
10 Year Cumulative0.8812230.188912
From 31/12/99 Cumulative0.8752220.307666
   
2 Year Annualised4.533.468442
3 Year Annualised6.315.573498
5 Year Annualised3.863.235162
10 Year Annualised6.906.21913
From 31/12/99 Annualised6.115.901789
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Mj9715 

 

Here is how you can do it. Make sure highlighted set specific output order is checked and order is sorted.

Workflow:

atcodedog05_0-1632386262689.png

 

Hope this helps : )

Labels