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 ID | Date | Amount |
| 1122 | 1/1/2024 | 120 |
| 2233 | 2/2/2024 | 230 |
| 3344 | 3/3/2024 | 320 |
| Table B |
| Transaction ID | Status | Date | Amount |
| 1111 | Pass | 3/1/2024 | 90 |
| 1122 | Fail | 1/1/2024 | 120 |
| 3344 | Pass | 3/3/2024 | 320 |
| Expected Result |
| Table A_Transaction ID | Table A_Amount | Table B_Transaction ID | Table B_Status | Table B_Amount | Flag |
| 1122 | 120 | 1122 | Fail | 120 | ID Available in both table |
| 2233 | 230 | - | - | - | ID Not avilable in Table B |
| 3344 | 320 | 3344 | Pass | 320 | ID Available in both table |
| - | - | 1111 | Pass | 90 | ID Not avilable in Table A |
Kindly help on achieving this!
