Alteryx Designer Desktop Discussions

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

Connected Worflow execution based on condition

praneshsapmm
8 - Asteroid

Hello ,

 

I have this requirement as mentioned below but not sure how to crack it . 

 

When data is like this :

Job Sub JobResult 
A1Success
A2Fail
A3Success
A4Fail

 

Then the workflow should trigger create output as Job A -Fail 

 

and 

 

When data is like this :

Job Sub JobResult 
A1Success
A2Success
A3Success
A4Success

 

Then the workflow should trigger another workflow connected to this .

 

Thanks.

8 REPLIES 8
flying008
14 - Magnetar

Hi, @praneshsapmm 

 

Do you mean that if the field [Result] column contains "Fail", no data will be output, or do you mean that another WF will not be run ?

praneshsapmm
8 - Asteroid

Hi @flying008 ,

 

Another workflow will not run if any of the sub job is fail. 

 

THanks..

flying008
14 - Magnetar

Hi, @praneshsapmm 

 

Please look that.

 

录制_2022_07_28_14_47_26_105.gif

praneshsapmm
8 - Asteroid

Hi @flying008 ,

 

Thanks for this . but unable to understand what is being done . Can you please explain . 

 

Thanks

flying008
14 - Magnetar

Hi, @praneshsapmm 

 

1- If your data contains the sub-job of A is Fail, then the message tool show error message like "Sub job A is Fail, The next task is canceled." and only output Job A -Fail rows by filter as you said. [the Message type must be select 'Error']

2- If your data don't contains the sub-job of A is Fail, then the workflow can run without errors. so will be enable events as set-up, thus automatically start other workflow file like Next_Job.yxmd.

praneshsapmm
8 - Asteroid

hi @flying008 ,

 

Can you share me the formula that is used to execute the next programs in the message tool .

 

Thanks

praneshsapmm
8 - Asteroid

Hi @flying008  ,

 

Does this requires access to server license or Engine API or Desktop automation . 

 

Iam trying to run from a simple designer .

 

Thanks

flying008
14 - Magnetar

Hi,@praneshsapmm 

 

1- yes, the event start other yxmd need you have designer automation license first.

2- If you don't have, you can try use conditional-runner of Crew-Macro to process it .

Labels