Remove duplicate rows of data based on minimum value

[chc9]

Hi,

Pls can you help me remove duplicated rows for Customer & Product and keep the Customer/Product combination with lowest price.

I could use Unique Customer/Product but that would not keep my lowest price for each Customer/Product combination.

Thank you,

[Qiu]

@chc9 

We can do a sorting for Customer & Product with Price being assending order, then use a sample tool to take the first one from group of Customer & Product.

[DawnDuong]

Hi @chc9 

you can use Summarize tool, with settings that

- group by: the fields that uniquely identify the combinations you need. In this case, you choose “Group by” customer and product 

- “Min” price

this way you can get the Minimum price for each combination.

dawn