Free Trial

Alteryx Designer Desktop Discussions

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

Analytic App -Condition

aideenfreeman
7 - Meteor

Hi all, 

 

I am trying to create an app and I am running into issues with the conditional tool. I am looking to run the filter tool "True" stream if "Document number column is not empty" is selected and "False" if deselected.

 

I am open to suggestion, the main reason for doing this as I want to run 2 entirely different workflows based on if the filter tool is true or false (i.e if the input contains a certain column or not)

aideenfreeman_2-1601993178517.png

 

aideenfreeman_1-1601993022448.png

aideenfreeman_3-1601993199873.png

 

Thanks in advance

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @aideenfreeman ,

 

Can you share the workflow so we can look more into it.

JosephSerpis
17 - Castor
17 - Castor

Hi @aideenfreeman I mocked up an app that should do what you are asking for. Let me know what you think?

aideenfreeman
7 - Meteor

Hi Joseph, thanks for the quick response. The workflow you have attached is on the right track, however, my false part of the filter is still running and producing a blank output.

 

I am wondering is there a way to only run the True OR the False part of the filter tool based on what the input file contains

(i.e if Document Numbers exist in the input, run one stream, if they don't exist run another stream.)

 

Maybe a conditional tool isn't the right way to go about this. 

 

 

 

 

JosephSerpis
17 - Castor
17 - Castor

Hi @aideenfreeman I mocked up a workflow that will check if the column is in the data. Let me know what you think?

atcodedog05
22 - Nova
22 - Nova

 Hi @aideenfreeman 

 

Here is an approach for the requirement.

 

Case 1:

atcodedog05_0-1601998936744.png

Output:

atcodedog05_1-1601998955589.png

Case 2:

atcodedog05_4-1601999016664.png

 

Output:

atcodedog05_3-1601998997369.png

 

Workflow:

atcodedog05_5-1601999060509.png

Based on your input it runs a workflow for true and another workflow for false.

 

Hope this is nearby.

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

atcodedog05
22 - Nova
22 - Nova

Hi @aideenfreeman ,

 

I just realized something a pretty simple approach.

 

Workflow:

atcodedog05_0-1601999521900.png

Filter Tool:

atcodedog05_1-1601999544432.png

 

If checkbox is ticked it will take True Anchor if not False Anchor. Give output similar to above scenario.

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

atcodedog05
22 - Nova
22 - Nova

Hi @aideenfreeman 

 

Check and let me know if these works for you 🙂

If not will be happy to help

Labels
Top Solution Authors