If Conditions

[AKPWZ]

Hi, I'm a student and just a beginner to this powerful technology.

I have a question regarding IF condition, actually I want to use IF condition between two workflows.

Say there are two workflow A & B, workflow A fetching data from a source which have 4 fields, but due to some technical issues it fetch only 3 fields for a date and throw an error.

So in this conditions I want a IF condition which run the another workflow which is ready with 3 fields if the first flow fail to execute. (Both A & B workflow are in the same repository)

Can anyone please help me on this please. Thank you!

[afv2688]

Hello @AKPWZ ,

depending on what you want to achieve with the conditions or how the look you may be able to do it without needing two workflows. Could you set up an example for me to help you better?

Regards

[mceleavey]

Hi @AKPWZ ,

Can you provide some mock data of what you're trying to achieve?

M.

[AKPWZ]

Thank you for your reply.

I'm attaching two screenshot here - each contain workflow which have the same logic.

- Screenshot with an error is workflow A  - it's fetching data from GoogleSheet - ABC which has 4 fields but it throw an error because it found only 3 fields out of 4 on a particular date, says 1st Jan 2021.

- Screenshot with 4 output field is workflow B - it fetched the data from Googlesheet - ABC were it found 4 fields on a particular date, say 2nd Jan 2021.

So I have written a workflow C which contain some logic to create 4th field (same name as it is in Googlesheet) with data. Now I want some Logic or IF conditions in between A & C and C & B.

When A fail it trigger workflow C, when C execution complete, it trigger workflow B and it's done.

I hope this is helpful - Please let me know if you have any further questions. Thank you!

[AKPWZ]

Thank you for your reply.

I'm attaching two screenshot here - each contain workflow which have the same logic.

- Screenshot with an error is workflow A  - it's fetching data from GoogleSheet - ABC which has 4 fields but it throw an error because it found only 3 fields out of 4 on a particular date, says 1st Jan 2021.

- Screenshot with 4 output field is workflow B - it fetched the data from Googlesheet - ABC were it found 4 fields on a particular date, say 2nd Jan 2021.

So I have written a workflow C which contain some logic to create 4th field (same name as it is in Googlesheet) with data. Now I want some Logic or IF conditions in between A & C and C & B.

When A fail it trigger workflow C, when C execution complete, it trigger workflow B and it's done.

I hope this is helpful - Please let me know if you have any further questions. Thank you!

[mceleavey]

Hi @AKPWZ ,

I still can't see the data. Can you mock up some data and provide an example of what you're trying to do?

M.

[AKPWZ]

Hi, So here I'm attaching 2 images ->

In the first image the workflow A fetching the data from Googlesheet with 4 column but due to some issue in api call it fetched only 3 fields for a certain dates (country column is missing). So to handle this I create another workflow, workflow B to fetch the coming 3 columns in the Googlesheet.

So I just want to know that is there any way or solution were I can trigger workflow B whenever workflow A fail to fetch 4 columns due to an issue in api call.

  

[pedrodrfaria]

Hi @AKPWZ 

I believe the WF below should give you a good idea of applying that logic

Use the Fiend Info to check how many columns you have (create a count with the summarize), if it has more than 3, move on with the workflow. If it has 3 or less, do the second API call.

Pedro.

[AKPWZ]

Awesome! Thank you so much. I'm all set now! Thank you for your help!!

[pedrodrfaria]

@AKPWZ 

Please remember to assign the solutions to the people that helped you get there. It is much appreciated.