Stop running data when condition is not fulfilled without producing an error message

[Roche]

Hi everyone, 

I am filtering data based on 6 month periods within a fiscal year.  It is checked based on 2 conditions and one of the 3 outcomes needs to be used.  If the condition is fulfilled at the 1st filter tool then that data is not needed and all I need to do is use the original data without the data from this outcome.  If, condition 1 is false and condition 2 is true, then I need the data from the 2nd append tool.  If condition 2 is false I need to use the data from the 3rd append tool.  I prefer for this setting to not produce an output, but to switch the flow of the data to include the data where the condition was fulfilled (except with condition 1 being true and that data not being used at all), i.e. so that I can then continue with calculations / joins etc from there onwards.

I will know that condition 1 is fulfilled if source_wi_calendar_month contains month numeric values or if there is 1 record at the T node of the 1st filter tool.  The same for condition 2 being true or false.  If one is true the other 2 will automatically be false and resulting in no records the other output nodes of the filter tools and correspondingly resulting in only null values for source_wi_calendar_month.  I need the flow to automatically pick the branch from which the data needs to flow.

2nd filter tool condition:

Would appreciate your help on this.  I attach a sample flow.

Thank you, 

Rouche

[Christina_H]

The easiest option here would be to make sure only one outcome produces data, and then union them all together.

All the filters are the same, source_calendar_month is not null

[Roche]

Hi Christina, thank you