If a file is not required every time how to skip that input file part

[joshikalyani]

I created an alteryx workflow, where it takes three different files as input.

So 3 workflows in one. But sometimes all three files are not required, in this case how can we ignore that part where that file is not there?

e.g. Workflow i've created looks like

Input file 1 - output file

Input file 2 - output file  Union of all three output file - Final output

Input file 3 - output file

Sometimes, input file 2 & 3 are not required. How to ignore it then as it shows error because there is no input file for that

[ShankerV]

Hi @joshikalyani 

One way is to create container and make it Disabled when there is no input.

When you have the input to be considered, then enable it and then run the workflow.

Many thanks

Shanker V

[joshikalyani]

Thanks for the reply. Yes its working but, what if we upload it on server can we do the same?

[ShankerV]

Hi @joshikalyani 

If its uploaded in the server, you can't manually change the Disable function as it will be automatically run at the scheduled time.

I can propose 2 ideas here. 

1. Upload both alteryx flows with one with Disabled checked and another with Disabled unchecked.

2. Or use the logic of dynamically changing Disabling the Tool container with logic in one workflow.

I will strongly suggest to go with option 2.

Many thanks

Shanker V

[joshikalyani]

I'm not sure how to apply condition for containers. If you can help

[ShankerV]

Hi @joshikalyani 

As I do not have the workflow, creating a sample use case where it will work to disable Input File 2 and Input File 3.

You can replicate the same in your workflow once I share.

[joshikalyani]

If you consider these 3 files as input files, Somtimes i dont require 121 & 111 files.  

I've created 3 workflows in one alteryx in 3 containers. For each container i've given name as input file name.

If this can help you

[Noble]

The best workaround for such situations is simply use a file with just the column headers.

[joshikalyani]

@Noble How can this be solution?

[joshikalyani]

Problem is how one of the three workflow can be skiped as per condition?