Problem with Group By

[#1]

Hi,

I am trying to load records from resident table but I am having problem, please see below:

SALES:
LOAD
CUSTNO,
VOL_ACTUAL,
ITEMNO
FROM (ooxml, embedded labels, table is Sheet3);

COMPARE:
LOAD
CUSTNO,
SUM (VOL_ACTUAL) AS VOL_ACTUAL
RESIDENT
SALES
GROUP BY
CUSTNO;

DROP TABLE SALES;

The above works fine, but when i include the ITEMNO, in says that there is an invalid expression:

SALES:
LOAD
CUSTNO,
VOL_ACTUAL,
ITEMNO
FROM (ooxml, embedded labels, table is Sheet3);

COMPARE:
LOAD
CUSTNO,
SUM (VOL_ACTUAL) AS VOL_ACTUAL,
ITEMNO
RESIDENT
SALES
GROUP BY
CUSTNO;

DROP TABLE SALES;

How can i include the ITEMNO field in the LOAD? Thanks in advance.

[Miguel_Angel_Baeyens]

Hello,

As you are using group by in your load statement, you should include field ITEMNO in group by.

Regards

[#3 · Accepted solution]

Dear try this one .......

COMPARE:
LOAD
CUSTNO,
ITEMNO,

SUM (VOL_ACTUAL) AS VOL_ACTUAL

RESIDENT
SALES
GROUP BY
CUSTNO,ITEMNO;

Bhushan N