topic Groupby error in Brasil

Groupby error

Anonymous — Sat, 21 Jan 2017 08:02:16 GMT

Hi,

please give me a solution for the below error..

Trend:

Noconcatenate LOAD

Pro_Tech ,

path ,

count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )Group by Pro_Tech;

it showing invalid expression ....i have attached qvd data also... urgent

Re: Groupby error

afurtado — Sat, 21 Jan 2017 18:16:50 GMT

Trend:

Noconcatenate LOAD

Pro_Tech ,

path ,

count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd ) Group by Pro_Tech , path ;

Re: Groupby error

Clever_Anjos — Mon, 23 Jan 2017 14:12:39 GMT

Your "Group by Section" must have all fields that are not aggregate into your LOAD section

Trend:

Noconcatenate LOAD

Pro_Tech ,

path ,

count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )

Group by Pro_Tech,path;