Alteryx Designer Desktop Discussions

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

output data into excel with specific format

187
8 - Asteroid

is there any way to output data like below? data row is dynamic and column is dynamic, and i want the second header is two rows below the grand total

187_1-1641447706392.png

 

 

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@187 
I think we can use a template maybe.

0106-187-A.PNG0106-187-A1.PNG0106-187-B.PNG

187
8 - Asteroid

@Qiu   Hi Qiu thanks for the quick reply,

 

Actually i need the header above id 4, so there are two headers row in one sheet

atcodedog05
22 - Nova
22 - Nova

Hi @187 

 

Slightly complicate here is how you can do it.

 

Workflow:

atcodedog05_0-1641452822280.png

 

Hope this helps : )

 

binuacs
20 - Arcturus

@187 as @atcodedog05 mentioned a a complex one 🙂 

 

binuacs_0-1641454509196.png

 

Labels