In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Output Tool - Use xls.

Barb_K
5 - Atom

Hello,

I have downloaded the database via office center for the 2nd time and had difficulty with that. 

I used my old workflow to do new analysis - everything seems to working great. Got the data I need it. Therefore I used after join tool the Output tool and try to save it to Excel. But unfortunately it's saving every line per new sheet. And I am not able to change that. 

Can you help on that?

How can I change the setting for Output tool to create whole file and not every line to have in extra sheet?

Thank you.

2 REPLIES 2
ChrisTX
16 - Nebula
16 - Nebula

Do you have the box checked for "Take File/Table Name From Field"?  Can you post a screenshot of your Output Data configuration?

 

 

Output to Excel.png

Chris

Barb_K
5 - Atom

Hello Chris, 

thank you for your hint. I removed the tick and it's working!!!!

Thank a million.

Barbora

Labels
Top Solution Authors