topic Conditional Join in Alteryx Designer Desktop Discussions

Conditional Join

anm252 — Sat, 26 Feb 2022 01:54:41 GMT

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.

Re: Conditional Join

Ben_H — Mon, 28 Feb 2022 16:21:07 GMT

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

Re: Conditional Join

Qiu — Mon, 28 Feb 2022 22:57:18 GMT

@anm252
What will be your output looking like?

Re: Conditional Join

anm252 — Fri, 04 Mar 2022 22:18:31 GMT

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