Formatting Output in Excel

[anhnguyenngoc2002]

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.

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

And this is my workflow in Alteryx

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

[Yoshiro_Fujimori · Accepted solution]

Hi @anhnguyenngoc2002 ,

Here is one way of doing this.

Workflow

Layout Tool (1st) configuration

Render tool configuration

Output

I hope this helps.

[anhnguyenngoc2002]

Hi @Yoshiro_Fujimori

Your solution really works!! Thank you so much