Beast mode - Join data from another line
Hi Domo community,
I would like to achieve a join from a single dataset.
Here is the column I have :
ID, Parent_ID, Parents_status, Comment 11 21 2 12 21 3 21 Done 1
I would like to do some beast mode to join data between lines and create two type of data:
Extract the parents status to apply it to the ID in the column Parent_status_New
And the child comment_sum which sum the number of comments attached
ID, Parent_ID, Parents_status, Comment, Parent_status_New, Child_comment_sum 11 21 2 Done 12 21 3 Done 21 Done 1 5
How should I create those beast mode? Do you have any idea how to do that?