Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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