Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Trend:
Noconcatenate LOAD
Pro_Tech ,
path ,
count(EmployeeID) as Count
FROM
[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]
(qvd ) Group by Pro_Tech , path ;
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;