Changing Data

[missteran]

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

[KimLamNg]

I think the Join tool should do the trick. Then you just need to keep or update the date.

[usmanbashir]

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!

[flying008 · Accepted solution]

Hi,@missteran 

FYI.