HI Alteryx community looking for some help. I have data where the dates for some ID are correct, and the dates for other IDs are incorrect. I have a separate table where i have the correct dates for the IDs that have the incorrect dates on them. How do i make it so that I add the correct dates only to those Ids that have wrong dates, while still keeping the others that are correct as is? I'm looking to do this without it being overly complicated, just looking for some thoughts. I've attached a dummy data set and also pasted the tables below.
Current State:
| Trade ID | Maturity date | |
| 757291 | 1/1/2025 | Incorrect date |
| 708658 | 8/22/2026 | Incorrect date |
| 033989 | 9/3/2025 | Correct date |
| 248022 | 5/1/2027 | Correct date |
| 552456 | 5/15/2024 | Correct date |
| 974652 | 6/5/2026 | Correct date |
Table with the Correct dates:
| Trade ID | Maturity date |
| 757291 | 3/31/2028 |
| 708658 | 8/22/2030 |
The result i'm looking for:
| Trade ID | Maturity date | Results |
| 757291 | 3/31/2028 | Correct date |
| 708658 | 8/22/2030 | Correct date |
| 033989 | 9/3/2025 | Correct date |
| 248022 | 5/1/2027 | Correct date |
| 552456 | 5/15/2024 | Correct date |
| 974652 | 6/5/2026 | Correct date |
