Join 2 data sets based on multiple column

Lara
Lara Member

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!!!

Comments

  • rado98
    rado98 Contributor

    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.

  • Lara
    Lara Member

    Thank you that works!!