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!
