Invalid Expression using max and group by

[Mike_Solfosko]

Hi everyone,

I'm having some issues with my script.

If someone could help me I would really appreciate.

Shop:
NoConcatenate
LOAD
distinct name_shop,
Address,
City,
Sales
FROM [lib://DataFiles/shop.csv]
(txt, utf8, embedded labels, delimiter is ';', msq);

Temp:
LOAD
distinct name_shop,
Address,
City,
max(Sales) as max_sales
resident shop

Group By name_shop;

[kaushiknsolanki · Accepted solution]

Hi,

You should add few more fields in group by statement of yours.

Temp:
LOAD
name_shop,
Address,
City,
max(Sales) as max_sales
resident shop

Group By name_shop,Address,City;

[Mike_Solfosko]

Thank you, it worked perfectly