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.
SOLVED

Pivot table report format

wenyg
8 - Asteroid

How to generate the pivot table output into an excel?

I put the following but when I open the excel output, the table doesn't show up but the output from browse tool looks correct.

wenyg_0-1675184934088.png

 

4 REPLIES 4
davidskaife
14 - Magnetar

Hi @wenyg 

 

To output data from a Reporting tool you need to use the Render tool 

DavidSkaife_1-1675185319426.png

 

configured like below for Excel

 

DavidSkaife_0-1675185274815.png

 

binu_acs
21 - Polaris

@wenyg use the Render tool instead of the output tool to get the table result into excel.

 

wenyg
8 - Asteroid

wenyg_0-1675185910474.png

hey that's the only option I have fir output mode and didn't give me the choice to link to a output file.

 

davidskaife
14 - Magnetar

@wenyg 

 

Scroll down, it's at the bottom - you need to pick 'Choose a specific output file' and select excel from that

 

 

Labels
Top Solution Authors