Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Oliver
thanks for your fast response
gidon