Replacing Data in Source File from Another File

[johnnyycchan]

HI all,

May I know how to update the status with field "Attend" in the file named Test11 by using file named "Test12"? The corresponsing files have attached for information. 

The desired result should show as follow : 

Before in Test11 : 

Name	Position	Attend
Alan	Manager	No
Ben	Officer	No
Charles	Officer	No
David	Supervisor	No
Eddie	Clerk	No
Fanny	Workman	No

After in Test11 : 

Name	Position	Attend
Alan	Manager	No
Ben	Officer	Yes
Charles	Officer	Yes
David	Supervisor	Yes
Eddie	Clerk	No
Fanny	Workman	No

Thanks.

Best Regards,

Johnny

[Qiu · Accepted solution]

@johnnyycchan 
We do a Join and union the two data streams afterwards.

[johnnyycchan]

It works now. Thanks a lot.