Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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