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 |
Solved! Go to Solution.
I think the Join tool should do the trick. Then you just need to keep or update the date.
One option: From current state table, filter out incorrect dates. Then union correct table. This will maintain the two first fields.
If you go the route of joining on Trade ID, you’ll have to use a formula tool and write a condition to choose the correct date.
Hope this helps!