Group Different Portfolio Items by Parent ID

Hi, I am working on a workflow that pulls in Rally ticket data from their API. What I am trying to do is identify Epics that are past due and their open features. The part that I am stuck on is associating the epic with the feature. I have the epic ID that links them, but a Join is not what I am thinking that I need. I would like the result to list the Epic Number and Name followed by the associated Features Number and Name. Example of ideal output below. Any help with this would be great

Ticket Number	Ticket Name	Status
E123	First Step	Open
F1234	Open Book	Open

Please let me know if further information is needed. Thank you for your help.

Help

Accepted answers

ChrisTX

I think the Union tool is what you're looking for, to stack data streams on top of each other. See attached workflow.

Chris

community example story.yxmd

All comments

ChrisTX

can you post sample input and desired output?

Link86

I have attached an example workflow with scrubbed data for the input. The desired output is in the excel file. All columns in the input should appear in the output.