I need to pull content together into one exported spreadsheet. I can easily get something like this...
Example 1
Rowid, Title, Description, Comment
1, title1, desc1, comment1
2,title2, desc2, comment2
3,title3, desc3, comment3
The problem happens when I get multiple comments for the same title. So, it needs to look something like this...
Exmaple 2
Rowid, Title, Description, Comment
1_1, title1, desc1, comment1_1
1_2, title1, desc1, comment1_2
2_1,title2, desc2, comment2_1
2_2,title2, desc2, comment2_2
etc.
I've used the joiner node to get to Example 1, but to do Example 2, I'm having trouble to join because the ids go from rowid0, rowid1, rowid2, etc, to rowid0_0, rowid0_1, rowid1_0, rowid1_1, etc. So, the comments won't effectively join with the other items that only have single rows. Is there a node or a configuration that can help?