Alteryx Designer Desktop Discussions

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

Formatting Output in Excel

anhnguyenngoc2002
7 - Meteor

Hi everyone,

 

I have some problems with formatting output. This is the output formatting data in excel after using Table Tool for 2 data frame & Union Tool.

anhnguyenngoc2002_0-1683974046496.png

 

This is my desired output in excel with distinguished label for every table.

 

anhnguyenngoc2002_2-1683974140392.png

 

And this is my workflow in Alteryx

anhnguyenngoc2002_3-1683974241934.png

 

 

How can I do to get desired result in Alteryx? Thank you for your help

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @anhnguyenngoc2002 ,

 

Here is one way of doing this.

 

Workflow

Yoshiro_Fujimori_0-1683979546839.png

 

Layout Tool (1st) configuration

Yoshiro_Fujimori_1-1683979631569.png

 

Render tool configuration

Yoshiro_Fujimori_2-1683979774370.png

 

Output

Yoshiro_Fujimori_3-1683979883954.png

 

I hope this helps.

anhnguyenngoc2002
7 - Meteor

Hi @Yoshiro_Fujimori

Your solution really works!! Thank you so much

Labels
Top Solution Authors