Average and gourp by with where clause in Load script

[Nefertary]

Hi Guru,

I Have created below script:

However It keeps giving me error:

Can anyone help?

[Anil_Babu_Samineni · Accepted solution]

You missed Non aggregate fields in Group By statement

Test:
LOAD Year_CattleSL,
week_No_CattleSL,
Avg(USDA_meat_prod) as Avg
FROM
Help.xlsx
(ooxml, embedded labels, table is Sheet1) Where Year_CattleSL=2016 Group By Year_CattleSL, week_No_CattleSL;

[Nefertary]

Thank you for the solution. It worked!!

[Anil_Babu_Samineni]

Great !! Please flag the correct answer If that resolved.