Conditional Join

[anm252]

Hi guys—I’m trying to do a conditional join on Table A to 1 of 2 columns of Table B based on the value in Table A. Table A column has the following values:

Client ID

534

541

542

548

1305

549

578

579

Table B has the following 2 columns I want to possibly join on:

Client ID         Profile ID

534                 541

534                 542

548                 1305

548                 549

548                 578

548                 579

What I’m trying to do is this: If Table A Client ID = 534 or 548 then Join Table A Client ID on Table B Client ID else Join Table A Client ID on Table B Profile ID. Is this possible to do? Any help is greatly appreciated. Thanks.

[Ben_H · Accepted solution]

Hi @anm252,

All joins are conditional really, in this case you can just do 2 joins one after the other.

For the first join, join on Client ID - Client ID (Assuming you don't want a cross join, and just the first record to match make unique first).

Then of the records that don't match (left output anchor) join on Client ID - Profile ID then union the two streams.

Regards,

Ben

[Qiu]

@anm252 
What will be your output looking like? 

[anm252]

Hi Ben--sorry for the slow response. This ended up working with a few additional conditions. Thankyou very much.