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
