Direct/Indirect Subordinates under a Manager - From HR Data Set

[P007]

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.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Producing-a-denormalised-output-from-H...

[PangHC]

@danilang agree. it will save more time by that way.

[P007]

Hi @danilang ,

This is the solution that I was looking for.

Thank you very much.