Analytical App: Two Outputs into Same Excel Workbook

Question

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!

ThePickleWizard · Answer

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 connections

File Output location in Analytical tool

Output for TWO

File Browser configuration

OTrieger · Answer

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

KGT · Answer

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?