I want to combine (union) 2 files and update values for common records at the same time

[GitaSivanandan]

How can I combine 2 data sets and at the same time update values in a particular field where common data is found across both data sets. Example below. Many thanks

[PhilipMannering · Accepted solution]

Hi @GitaSivanandan 

Here's how you can do it,

[GitaSivanandan]

Thank you Phillip for your quick reply