Join 2 data sets based on multiple column

Lara

Hello,

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?

 

Thank you!!!

rado98

The way I have done similar things in the past is

Do a join on hte first column

Do a join on the second column as a separate step

Depending on your data you might even need to filter out all the row form the first join and append them on a later step.