Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
21 - Polaris
21 - Polaris

@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
21 - Polaris

@187 as @atcodedog05 mentioned a a complex one 🙂 

 

binuacs_0-1641454509196.png

 

Labels
Top Solution Authors