Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Browse row where the Customer has atlease n rows

Hi All,

There are multiple records of customers in a table. 1 customer can have multiple rows on different dates.

I want to see the customer_id and it count where a customer_id has more than 3 rows in a dataset. How would i achieve this. Thanks




Alteryx Certified Partner

A Summarize tool can group on customer_id and count the number of records that it find for each group. A Filter tool can then filter those results to only those with a record count greater than 3. I have attached an example.