Join on Multiple Criteria with Or Statement

Follow

Joshua Barnett

• July 02, 2018 19:13

I am wondering if there is a way to join two datasets with one column or another column (ie. match on customer code or on custmer name). It seems that if you specify multiple criteria in the join it is always an and statement. Thanks.

0

• 

  Sabeel

  • July 02, 2018 20:32

  Hi Joshua,

   

  Could you please provide some example of this problem statement, just to interpret this query accurately?

  Regards,

  Sabeel

  0

  Comment actions Permalink
• 

  Joshua Barnett

  • July 09, 2018 20:07

  Below is an example. I need to join based on Customer Number or Customer Identifier to pull in the "data to be pulled in Join" column in the right table (left join). You can see sometime there is a match on only number or identifier in the original table. I do not see an easy way to accomplish this.

  0

  Comment actions Permalink
• 

  Joel Stewart

  • July 09, 2018 20:27

  What do you expect the output to look like if a record matches both values? Is there any time where a record would match differently between the Customer Number and Customer Identifier? Also, what size are the data sets? This can influence how complex a solution should be versus how performant. 

  My initial thoughts are to join based on the Customer Number only. Independently join on the Customer Identifier. Then union these two sets and use grouping to eliminate potential duplicates. 

  1

  Comment actions Permalink
• 

  Joshua Barnett

  • July 09, 2018 20:46

  This strategy should work. Thanks. The identifier and number should always be linked to the same person.

  0

  Comment actions Permalink

Please sign in to leave a comment.