hierarchy automation by Iterative macro

[Meghnagupta]

I have uploaded 1 file Hierarchy_Template which is Input file in this.

1st we have to put filter on Type = Profit center

Then we have the data which will pick ID.

Afterwards we need to pick "ID" column value say "74226" then we will pick it's Parent ID "43420" this will be hierarchy 1

and then we will search 43420 in "ID" column again and pick parent ID "43388" this will be hierarchy 2

again we will search "43388 in "ID" column and pick parent ID till we get P001

which searching till P001 we will remove filter of Profit Center

and then it will pick next "ID" after putting filter of Profit center

Is this possible in Alteryx?

Can someone help me creating this workflow?

[Meghnagupta]

@binu_acs could you please help me in this?

[binu_acs]

@Meghnagupta I dont see the Parent ID 43420  and 43388 in the ID column of the given input (Hierarchy tab), can you also provide the expected output