Alteryx Designer Desktop Discussions

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

Merge Header

BautistaC888
8 - Asteroid

Hello,

 

I have this data structure as input:

BautistaC888_0-1635887513732.png

And i need to get this output:

BautistaC888_1-1635887640726.png

With twp merged headers and an empty cell for the firs column.

 

I share an example.

If you can help me i will appreciate it.

Thank you.

2 REPLIES 2
jonnyrask
8 - Asteroid

Hi @BautistaC888 Alteryx does not support merging columns.

 

Having said this one workaround is that you can create a template with the first row already added, then when you output the data just select the template xlsx and select the option to append the data. 

atcodedog05
22 - Nova
22 - Nova

Hi @BautistaC888 

 

You can create merge headers with help of reporting by aligning them part by part to reach the desired output.

 

Workflow:

atcodedog05_0-1635923711778.png

 

Output:

atcodedog05_1-1635923725463.png

 

Hope this helps : )

Labels