Hello,
I am trying to design a solution to update the unique count for each customer. I have a large data set in which Qty of the customers duplicates in an inconsistent way which provide inaccurate result in my analysis. Could anyone please assist me in drawing a flow that provides the correct result i.e. 1 Qty for each customer? Please refer to the attached file for the details.
hi @Learner09
I suppose your demand can be realized by simply using Summarize or Sort/Sample, if you want to extract MAXIMUM Qty. of each customer.
Either way of using Summarize or Sort/Sample can be OK in this case. Please refer to 1st container in attached workflow.
Moreover, if you want to have a format like your attached Excel file(maintain original record, and add column with max Qty. at first row, and 0 for the rest for each customer), please refer to 2nd container in attached workflow.
I'm thinking that this can also be achieved by the Tile Tool and the Summarize Tool.