I have two sets of data that are similar to this:
File A
Name | Height | Colour | TPM | Manager |
Amy | 6 | Red | 10 | Kris |
Bob | 6 | Green | 10 | Yuri |
Carl | 6 | Blue | 10 | Wendy |
Derrick | 5 | Purple | 10 | Anna |
File B
Name | Age | APR | TPM | Director |
Amy | 20 | 3 | 10 | Jeffrey |
Elay | 21 | 5 | 10 | Manny |
Carl | 22 | 3 | 10 | Tiago |
Fred | 20 | 2 | 10 | Veronica |
Wherever a name from file A occurs in file B, I want to replace the manager in file A with the one in file B. For example, an output here would be:
Name | Height | Colour | TPM | Manager |
Amy | 6 | Red | 10 | Jeffrey |
Bob | 6 | Green | 10 | Yuri |
Carl | 6 | Blue | 10 | Tiago |
Derrick | 5 | Purple | 10 | Anna |
As you can see, Amy and Carl's managers have been updated. (EDIT) Note; In one file, the column name is Manager whereas in the other it is Director (EDIT) How do I go about doing this?
Solved! Go to Solution.
Hi @shaheer
One way of doing this, just be careful with duplicated names. If you have any ID field related to these names to use as join key, it would be better.