I have two sets of data which are similar in structure (columns, datatypes) but different in contents. Based on a set of conditions (in my case only variables) I want to determine, which of both sets of data is loaded to the workflow to be processed with the same logic.
An obvious solution would be to use an IF-ELSE-Processor for this. But - unless I missed something - in this scenario, I had to duplicate the logic in the remainder of the workflow, which I want to avoid because it is exactly the same. Another solution was to create a smaller workflow which evaluates the conditions in an IF-Else-Processor and saves the right data to an intermediary table, which avoids redundancy but isn’t too pretty. Another solution I came up with is to include all the relevant variables to the table name but this bloats up table names, which I also don’t like.
What I am looking for is more or less an IF-ELSE-Processor with two input ports and one output port. In case the statement(s) evaluate to TRUE, the left input should be read and forwarded and otherwise the right. Has anyone found good solution to this?