Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Joining Two Tables and Creating Flag

Vigneswaran
7 - Meteor

Dears, 

I'm stuck in joining two tables with respect to common ID. After joining, i need to create one flag which gives the result of join (please refer to resultant screenshot). 

Table A
Transaction IDDateAmount
11221/1/2024120
22332/2/2024230
33443/3/2024320

 

Table B
Transaction IDStatusDate Amount
1111Pass3/1/202490
1122Fail1/1/2024120
3344Pass3/3/2024320

 

 

Expected Result
Table A_Transaction IDTable A_AmountTable B_Transaction IDTable B_StatusTable B_AmountFlag
11221201122Fail120ID Available in both table
2233230---ID Not avilable in Table B
33443203344Pass320ID Available in both table
--1111Pass90

ID Not avilable in Table A

 

Kindly help on achieving this!

2 REPLIES 2
nagakavyasri
12 - Quasar
Vigneswaran
7 - Meteor

Thanks a ton! Great one!

Labels