Two or More Dataflow in a Single Workflow - Output saved in the same single File - Error

Hi All,
There are two or More Data Flow from different input source in a single Alteryx Workflow (ex.-Database input like SQL). If there is an error on first flow or any of the data flow like SQL Query, then Any of the Data Flow would not happen (i.e)Output will not be saved even for one flow with error, In this case output file is same throughout with different sheet name, How do I achieve this? Below is simple Example.

Regards

Eswaran

Workflow

Datasets

Developer

Common Use Cases

Best Practices

Apps

Preparation

Download

Interface Tools

Data Investigation

Accepted answers

philipmannering

What about cancelling the workflow from the Runtime Settings in the Configuration Pane?

Screenshot 2023-07-14 085728.png

All comments

philipmannering

What about cancelling the workflow from the Runtime Settings in the Configuration Pane?

Screenshot 2023-07-14 085728.png

ArnaldoSandoval

Hi @Eswaran

If I understood you, your scenario is a workflow reading two or more Excel files, and you want to combine the data from those input files into a single Output file with as many sheets as input Excel file, actually, one tab per input file, if that's the case, the attached workflow perform exactly that, its workflow is shown below:

There are two important items in this workflow:

There is a common column between all the input Excel files telling apart the data; if the Excel files do not have a common field, just add one, as shown in the workflow, in this example "Source" was implemented. Note: The Region file is comun to the input Excel file in the attached workflow.
You should configure the Output tool properly, so it will write to a single Excel file, with multiple sheets, one per input file.

This is the Output tool configuration, the red-yellow arrows point to the configuration parameters used to get the expected output.

Hope this helps,

Arnaldo

Multi-WF-Single-Excel-01.yxzp

Eswaran

Thanks @PhilipMannering .. it works for my situation..

Eswaran

Thanks @ArnaldoSandoval ..

Thanks for your wonderful time...

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335