Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Analytical App: Two Outputs into Same Excel Workbook

ThePickleWizard
7 - Meteor

Hi,

 

I am trying to use one 'file browser' interface tool connected to two output tools that go to the same Excel Workbook outputting to separate tabs named 'One' and 'Two'.
Maybe, the file browser is not the right tool. But we want to use the Analytic App for this.
Any help with this will be greatly appreciated!

Many Thanks!

3 REPLIES 3
KGT
11 - Bolide

So that the user can select where to save the file? You should be able to do it, it will require a separate Action Tool for each output tool.

 

What's the issue that you're running into?

OTrieger
12 - Quasar

@ThePickleWizard 
I'm not sure if I managed to really understand what you want, however if I do understand it, then you can use Detour Tool as this tool can route the data into 2 different ways based on User selection, it will indicate to Alteryx if the data should go to the Right or to the Left and based on it you can connect the output to One or Two Tabs based on the used selection. 


But as I said, I did not fully understand what you are trying to do.

ThePickleWizard
7 - Meteor

Thanks for the response and sorry for the confusion
When I run the analytic app and select the file output location, it only outputs the ONE tab not the TWO tab.

 

The goal is to have the user use the analytical app and when the user selects the file output location the workflow should output to one excel file with 2 tabs named ONE Tab and TWO tab.

 

Tool connectionsTool connections

 

File Output location in Analytical toolFile Output location in Analytical tool

 

Output for TWOOutput for TWO

 

File Browser configurationFile Browser configuration

 

Labels