Hi, I am working on a workflow where I am using the above attached input, In the given data first 7 columns are same and then from purchase to Surplus it differs.
I want output wherein the duplicate
data having same rows in first seven columns gets removed and it shows up only first row and then in the last surplus amount column the amount in the first row shows up as 9265.62 and then in the remaining 6 rows having the same amount it covert into zero as i am attaching in the image of output i want to get.
Any help on this please?
Thanks in Advance
hi @Tid14
please share your attachments again as its not clearly visible.