Iterative Macro - Multiple VLOOKUPs

[JeffJeffrey12]

Hello everyone,

I am trying to generate a "path" of managers.

Basicly I want to have it in my data after the Iterative Macro like this:

USERID	Manager	Manager2	Manager3	Manager4
A	B	C	D	E
B	C	D	E
C	D	E
D	E
E

This is my first time trying to create a macro.

This was my approach - attached.

Maybe someone has an idea and can help out?

Right now I am doing like 20 "Find/Replace" modules after each other which isnt really looking nice and is complicated to manage if I want to change something.

Thanks in advance!

[Armon24 · Accepted solution]

Hi @JeffJeffrey12 

I believe this post should help: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Displaying-Hierarchy-of-Managers/td-p/... 

[JeffJeffrey12]

I didn't have time to get back to this topic yet but I will check on it, whenever I can.

Thanks so far @Armon24 

[JeffJeffrey12]

@Armon24 It helped.

But I have a further question.

Imagine following dataset:

	Hierarchy
User	1	2	3	4	5	6	7	8	9	10
z	b	c	d	e	f	g	h	i	j
h	y	x	w	v	l	k

As you can see User "h" has his own hierarchy as well as being inside the hierarchy of User "z".

I would need a way - maybe another iterative macro - to automatically check all hierarchy levels for the Users and if found to attach the Users Hierarchy to the one found from the level its found in.

In this example I would need to have two rows of hierarchy for User "z":

	Hierarchy
User	1	2	3	4	5	6	7	8	9	10
z	b	c	d	e	f	g	h	i	j
z	y	x	w	v	l	k	h	i	j

I hope I could explain what I am trying to solve manually somehow right now.