Hi All,
I am facing a challenge while using for loop with a left Join
Requirement- I have two tables one having list of Area Name and employee IDs, the other having Employee IDs to manager IDs mapping
| Table 1 |
| Area Name | Employee ID |
| A | 123456 |
| B | 1234567 |
| C | 234567 |
| D | 345678 |
| Table 2 |
| ID | Manager ID |
| 123456 | 1234 |
| 1234567 | 1234 |
| 234567 | 2345 |
| 345678 | 3456 |
| 3456 | 34 |
| 1234 | 12 |
| 2345 | 23 |
Task-
I need to Left Join Table 2 into table 1, so that the resultant table looks like below
| Table 1 |
| Area Name | ID | Manager ID |
| A | 123456 | 1234 |
| B | 1234567 | 1234 |
| C | 234567 | 2345 |
| D | 345678 | 3456 |
Other Steps-
1. Make a temp table of Table 1
2. Drop field Terr ID from Temp Table
3. Rename Field Terr Manager ID as Terr ID
4. Concatenate Temp table with Table 1
Challenge-
I need to repeat the process until there is no Manager ID mapped to an employee id. For example 12 in my case
.png "Former Employee"){kind=icon}
