Hi Community,
I am stuck with an issue though I figured out the solution by going through one of the community solution but current fresh issue that I am facing is that when I am running the iterative macro it goes into infinite iterations because I have a record totaling upto 100,000 which is being iterate.
Major field that I am using is Emp ID, Emp Name, Supervisor Name , Supervisor ID.
Employee Name | Employee ID | Supervisor Name | Supervisor ID |
Amandeep | 123 | Imran | 101 |
Pravir | 387 | Pankaj | 253 |
Bhupendra | 309 | Pankaj | 253 |
Bhatia | 388 | Pankaj | 253 |
Chaurasia | 299 | Sheeraz | 234 |
Sweta | 289 | Sheeraz | 234 |
Jasmeen | 201 | Imran | 101 |
Imran | 101 | Jitendra Dua | 100 |
Jitendra Dua | 100 | Nick | 98 |
Ronak | 124 | Nick | 98 |
Shivendra | 286 | Nick | 98 |
Vishesh | 125 | Imran | 101 |
Nick | 98 | Nancy | 56 |
Nancy | 56 | Toby | 7 |
toby | 7 | ||
Pankaj | 253 | Amandeep | 123 |
Sheeraz | 234 | Amandeep | 123 |
NOTE - The points that needs to be noted here is that my data set is not limited to only this much record , because I have data set which contains 100,000 records all together.
Output which I want is :- Based on the user input (Either be it single or multiple - like for an example User input employee id as 101 , 253) so based on the input I should be getting the output se below :-
Supervisor Name | Supervisor ID | Employee Name | Employee ID |
Imran | 101 | Amandeep | 123 |
Imran | 101 | Jasmeen | 201 |
Imran | 101 | Vishesh | 125 |
Imran | 101 | Pankaj | 253 |
Imran | 101 | Sheeraz | 234 |
Imran | 101 | Pravir | 387 |
Imran | 101 | Bhupendra | 309 |
Imran | 101 | Bhatia | 388 |
Imran | 101 | Chaurasia | 299 |
Imran | 101 | Sweta | 289 |
Pankaj | 253 | Pravir | 387 |
Pankaj | 253 | Bhupendra | 309 |
Pankaj | 253 | Bhatia | 388 |
Also , you may visit the link which has similar datasets and similar solutions but the exact solution which I am looking for is still under search.
Solved! Go to Solution.
@danilang agree. it will save more time by that way.