In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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 : )

 

binu_acs
21 - Polaris

@187 as @atcodedog05 mentioned a a complex one 🙂 

 

binuacs_0-1641454509196.png

 

Labels
Top Solution Authors