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
Solved! Go to Solution.
@johnnyycchan
We do a Join and union the two data streams afterwards.
It works now. Thanks a lot.