2 Replies Latest reply: Jan 23, 2017 9:12 AM by Clever Anjos RSS

    Groupby error

    Yuvaraj G

      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
          Alessandro Furtado

          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

            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;