If I understand you properly, you need to filter 2 groups from master table one with Alle and other without. For first group do a cross join to the analysis table and for the second use regular join. Combine the result of joins with Concatenate node.
Make one additional step on top of what @izaychik63 suggested. Split your masterfile in 4 groups (alle-alle), (… - alle), (alle - …) and the rest. Inner join each group on 2, 3 or 4 columns out of your analysis file and concatenate the results together.
You could use e.g. a Rule Engine node to create an additional column assigning the group and four Row filter nodes to split the masterdata on this new column. Or four Rule-based row filter nodes to get this done wihout adding a new column.
According to me there is a simpler solution but I have to ask uou a question:
in analysis table (in workflow you posted) there are a lot of records without destination data.
What does it mean? Do you wantjoin these records with all records in master table that have the same source data (or Alle) independently destination data contained in them?
In an ideal world, all records would have destination data. They will at some point, but I don’t have them yet. So, for my join at the end these empty records will not be considered (which is fine for now).
But yes, basically I need to join all 4 columns with each other in order to get the one column “value to retrieve”.
