How do I update new data?

[etcbiz]

Hello,

I have a data set that I'd like to update for only one specific field. I'm having trouble using the Find/Replace and Join tool and thought I'd ask. So the overall goal I'd like to accomplish and append Table 2 to Table 1 but then replace the row that has an updated and new finish date. As you can see below. I can add in the new data from Table 2 to Table 1 but it ends up creating a new instance for Sarah. I'd like to be able to update the Sarah/Client2/Project2 to update with the new finish date and the new billing type. Table 3 is what i'd like to be able to produce. Any help would be much appreciated!

Table 1 (Original):

Client	Project	Staff Member	Start Date	Finish Date	Billing Type
Client1	Project1	Joe	1/1/2022	6/5/2022	Hourly
Client2	Project2	Sarah	10/5/2021	3/5/2022	Weekly
Client3	Project3	Billy	9/15/2022	9/1/2023	Weekly

Table 2(New Data):

Client	Project	Staff Member	Start Date	Finish Date	Billing Type
Client4	Project4	Barry	1/1/2023	6/5/2024	Hourly
Client2	Project2	Sarah	10/5/2021	8/5/2022	Hourly
Client5	Project5	John	4/15/2023	9/1/2024	Weekly

Table 3 (Final output):

Client	Project	Staff Member	Start Date	Finish Date	Billing Type
Client4	Project4	Barry	1/1/2023	6/5/2024	Hourly
Client2	Project2	Sarah	10/5/2021	8/5/2022	Hourly
Client5	Project5	John	4/15/2023	9/1/2024	Weekly
Client1	Project1	Joe	1/1/2022	6/5/2022	Hourly
Client3	Project3	Billy	9/15/2022	9/1/2023	Weekly

[binuacs]

@etcbiz one way of doing this

[etcbiz]

In the Join tool, would I have to set all the Fields that I want to be joined at (except for finish date and billing type)?

[etcbiz]

In the Join tool, would I have to set all the Fields that I want to be joined at (except for finish date and billing type)?

[binuacs]

@etcbiz You can join with any unique fields in the join tool. In this case you can use client as the key