I have the following tables:
DF#1
| Name | Manager | Date |
|---|---|---|
| Alice | Mary | 2022-12-23 |
| Bob | Mary | 2022-12-15 |
| Charlie | Danny | 2022-12-02 |
DF#2
| ID | Name | Location |
|---|---|---|
| 13 | Alice | Canada |
| 25 | Charlie | Thailand |
| 79 | Alice | Canada |
| 101 | Bob | New Zealand |
Expected Result
| ID | Name | Location | Manager | Date |
|---|---|---|---|---|
| 13 | Alice | Canada | Mary | 2022-12-23 |
| 25 | Charlie | Thailand | Danny | 2022-12-02 |
| 79 | Alice | Canada | Mary | 2022-12-23 |
| 101 | Bob | New Zealand | Mary | 2022-12-15 |
Basically I need to add two columns and the value of the two columns added are "lookup" based on the "Name".
Thanks in advanced!
