get one prodcut from each product family

[gidon500]

hello guys 

I have a list of 49932 pruducts  contained in  448 product familes

I want to get a table of 448 line with only one product for  each  family (any product )

any ideas how to make it

enclosed is the data file with two colomns

product , productfamily total of 49932 rows

thanks

gidon

[ogautier62 · Accepted solution]

Hi,

once you've loaded your product table add :

productFamily:

load min(Product) as myProduct, ProductFamily resident product group by ProductFamily;

you could use max too

regards

[gidon500]

Hi Oliver

thanks for your fast response

gidon