I have a case I have yet not found a solution for. The case is that I have prognosis, and historical data, which comes from two different streams in the workflow and then joined. However, if a certain company xxx does not have any historical data, then i dont want any data flowing further in the left stream of the join.
That is, there is a condition before the join which is that [Total_sum] !=0. If company xxx has [Total_sum] = 0, it means that it will go to te left in the join, and I want to stop all data flowing through the left as it goes further to a union.
Is there any good way of achieving this ?