What I want is to move the amount from "Child" row all to the "mother" row if they have the same Parent Alias. Please see the attached as reference. thank you!
Solved! Go to Solution.
I have another question, if you don't mind, do you know how to merge those who have the same "Parent Alias" into one cell? they will merge into one cell or if there's no functionality like that in Alteryx is there any workaround to do that to merge all the same value(Parent alias) in one cell?
Attached is the sample output I want in Alteryx.
My issue has been resolved. Thank you all! :)