How can I get the last sales date for each product in the script?

[hildacgg]

I need to upload only the last day when the product was sold, please help!

[kaushiknsolanki]

Hi,

You can use the max function.

Load Product,Max(SoldDate) as LastSoldDate

From xyx

Group by Product;

Regards,

Kaushik Solanki