Join 2 data sets based on multiple column
If I want to join 2 datasets, but the matching column can be multiple, how can I do it with ETL?
When using join data and selecting "match another column" it is not working as an "or" condition.
What I would like it to find all the matches between 2 columns, and then go to 2 other and do the same.
Is that possible?