browse folder path to multiple Outputs

All,

I am trying to link one folder path to 4 outputs, so that when executed, the path given in the browse, is where the out puts needs to be saved.

the Output file is just one, but the outputs are saved in each tab in XLSX.

The current design gives an error

Output

Accepted answers

Atson

Tried turning AMP off and that resolved the issue.

Here is a link for the help on AMP. https://help.alteryx.com/20221/designer/alteryx-amp-engine

All comments

CoG

The issue is that you have multiple attempts to write to the same file occurring all at once, which doesn't and won't work. There are many other community posts addressing this, so you are in good company. The Block Until Done tool is one way to solve this problem:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-results-to-different-sheets/td-p/59403

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Workflow-output-as-different-sheets-in-one-Excel-sheet/td-p/649803

are a couple such links to get you started. Hope this helps!

Qiu

@Atson
Try to use the Block Until Done tool?

Atson

Tried turning AMP off and that resolved the issue.

Here is a link for the help on AMP. https://help.alteryx.com/20221/designer/alteryx-amp-engine

jsowinski0619

were you able to get the folder browse tool to work? i'm looking to do the same thing ... specify a folder location, then the workflow creates a file with multiple tabs. so the one folder browse will dictate where 5 outputs go (into one file). would you mind sharing the workflow?

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157