We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Switch flow on the basis of error (Absence of 1 column)

ShantanuDagar
8 - Asteroid

Hey all,

 

I have attached image of workflow and a basic description.

 

I have a workflow which have 4 subworkflows in it on the basis of different input files.

 

Each sub-workflow takes in the input files from the common folder on the basis of name, performs some tasks, create a report.

 

Then the reports are stacked together and rendered in 1 excel file.

 

 

I am running into 1 issue. All 4 subworkflows as you can see are in a tool container each.

 

Now in the 2nd (top-right) workflow, input file has 2 possibilities wrt 1 of the column. Either it can be present or it can be absent. It changes week by week.

 

If it is present, then the workflow has been created and it works fine. But if it is absent, then the error comes as expected. And the final output doesn't give anything.

 

I want to have a solution for this problem in 2nd workflow. If column B is present then this flow as it is and if column B is absent then a different flow which ultimately meets the other 3 outputs as it is right now. 

 

So that no error comes.

 

Thanks

1 REPLY 1
ArtApa
Alteryx
Alteryx

Hi @ShantanuDagar - Here is a simple solution to add a column, if it does not exist. It will solve your problem:

 

ArtApa_0-1674515673768.png

 

Labels
Top Solution Authors