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
Solved! Go to Solution.
What about cancelling the workflow from the Runtime Settings in the Configuration Pane?
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:
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
Thanks @PhilipMannering .. it works for my situation..
Thanks @ArnaldoSandoval ..
Thanks for your wonderful time...