Table Transformer - List Epics and Issue Story when Epics have identical summary texts

[Matthias Mödinger]

Hello,

I have a project with Epics with Stories that are linked as "Issues in epic".
The summary of the Epics can have an identical names in my project.
This turns out as a big problem in Jira, because the Story 'Epic Link' is not a key or anything unique, it is the summary text. 

In Table Transformer I have 2 tables with the epics and with the stories.

Now I want to join them in one table.
I found no way to get to the "Issues in epic" information 
and as said before the Epic Link of a Story links all Epics with that name but not the one parent Epic.

How I do this?
Thank you

[Daniel Berežnoi]

Hi Matthias,

This is Daniel from the Stiltsoft team, the creators of Table Filter, Charts, and Spreadsheets.

Does the Issues in Epic column contain story summaries or issue keys? 

If the column contains issue keys, then you can use a modified query from our documentation to split the issue keys in the Issues in Epic column into separate rows. Then, you can JOIN the tables together based on the issue keys.

Let me know if this helps.

Daniel