Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

identify records by their parents Essbase retrieval

Highlighted
7 - Meteor

I have a situation where I want to define a wok-flow that reads essbase extract sheet and brings up the parent for each record next to it. Refer to the attached EXCEL for actual vs Expected

Highlighted
17 - Castor
17 - Castor

hi @chinu267 

 

Here you go.  Start by adding a recordID.  Reverse your list. detemine the Parent using a multi-row tool, sort in ascending order.

 

solution.png

 

Dan 

7 - Meteor

Thank You for your help and quick turn around. assigning a record ID and reverse sorting did the trick for me. 

Labels