Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Unique Count for each customer

8 - Asteroid



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.

15 - Aurora
15 - Aurora

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.


11 - Bolide

I'm thinking that this can also be achieved by the Tile Tool and the Summarize Tool.

  • Tile by the Unique Values under [Customer Number]
  • At the same time, Summarize to get the [Max Qty] for each [Customer Number]
  • Join the Summarized data to the Tiled data
  • Use the Formula tool to use the [Max Qty] for each record where [Tile Sequence Num] = 1, and zero for everything else. [Tile Sequence Num] = 1 refers to the first record for each [Customer Number].

Alteryx - Learner09 Unique count.png

14 - Magnetar

hope this helps