community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Issue with Iterative macro

Meteor

Hi I have got a macro working that shows the total hierarchy of charges that goes from parent to child untill there is no further parent for a child or if parent is already exists in the loop. 

 

Now what i want to add is chargtypes to the loop and see if we can loop though for each charge type that i am not able to get it to work

 

e.g input 

ParentChildChargeChargePathPathAccountPathAccount
2-L23-L11001003-L1 < 2-L2A100A100
2-L23-L11001003-L1 < 2-L2A200A200
2-L23-L11001003-L1 < 2-L2A300A300
1-L32-L22002002-L2 < 1-L3A400A400
1-L32-L22002002-L2 < 1-L3A200A200
1-L32-L22002002-L2 < 1-L3A500A500
4-L23-L1100010003-L1 < 4-L2A100A100

 

Output i get is:

 

ChildChargeChargePathPathAccountPathAccountRParentRChildRChargeRAccountENDRepeatHierarchy
3-L1100010003-L1 < 4-L2A100A100    Y 1
3-L1100100 <3-L1 < 2-L2 < 1-L3A100A400 2-L2200 Y 2

 

 

it does not take into account all Accounts i.e A200,A300.

 

Attached workflow with macro, TIA

Alteryx
Alteryx

 @vinay4444 I am not clear from your post what it is exactly that you are trying to achieve. Can you clarify your use case and what you expect the output to look like?

Labels