Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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;
Thank you, it worked perfectly