join two excel spreadsheet then using outer join to update/replace reference spreadsheet

[ashamluo]

Hello Alteryx Community,

I have been searching on the community for this topic, but could not find any. Not sure if this is possible to do, I would really appreciate if you could help.

I have two spreadsheet (#1 and #2) and i joined them together, if there is new data then I would get rows in my right/outer join (which is the data that I am concern of).

Then I have a spreadsheet call reference,

what I want to do is to look at the rows from reference spreadsheet and replace entire row that matches two records (country and holiday) from the result of the joined spreadsheet. 

#1

country	holiday	date	day	school	bank
Argentina	new year	01-01-2022	Saturday	close	close
Argentina	Public Sector Holiday	01-13-2022	Thursday	open	open
Argentina	Public Sector Holiday	01-14-2022	Friday	open	open

#2

country	holiday	date	day	school	bank
Argentina	new year	01-01-2022	Saturday	close	close
Argentina	Public Sector Holiday	01-13-2022	Thursday	open	open
Argentina	Public Sector Holiday	01-14-2022	Friday	open	open
Brazil	labor day	05-01-2022	Sunday	close	close

Outer Join of #1 and #2

country	holiday	date	day	school	bank
Brazil	labor day	05-01-2022	Sunday	close	close

Reference

country	holiday	date	day	school	bank
Argentina	new year	01-01-2022	Saturday	close	close
Argentina	Public Sector Holiday	01-13-2022	Thursday	open	open
Argentina	Public Sector Holiday	01-14-2022	Friday	open	open
Brazil	new year	01-01-2022	Saturday	close	close
Brazil	labor day	05-01-2021	Monday	open	open
Colombia	Epiphany	01-06-2022	Thursday	close	close

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Outcome that I want (entire brazil/labor day being updated from this reference table)

country	holiday	date	day	school	bank
Argentina	new year	01-01-2022	Saturday	close	close
Argentina	Public Sector Holiday	01-13-2022	Thursday	open	open
Argentina	Public Sector Holiday	01-14-2022	Friday	open	open
Brazil	new year	01-01-2022	Saturday	close	close
Brazil	labor day	05-01-2022	Sunday	close	close
Colombia	Epiphany	01-06-2022	Thursday	close	close

Thank you so much!

[Qiu · Accepted solution]

@ashamluo 
I think it is basically Join and Union as below

[ashamluo]

Oh my goodness! I don't know this just did not come to my mind! thank you!