3 Replies Latest reply: Nov 5, 2015 6:26 AM by balraj ahlawat RSS

    aggregation prob

    jhonatan ben ami

      hey i am getting this messgae while trying to run the script below the image:

      aggregation prob.PNG

       

      [Trans]:

      LOAD [DOC],

      [PART],

      [QUANT]

      FROM [lib://clinton/Trans.qvd]

      (qvd);

       

       

      load DOC , PART

      from [lib://clinton/Trans.qvd]

      (qvd)

      GROUP BY "DOC"

      ;

        • Re: aggregation prob
          Gysbert Wassenaar

          The error Aggregation expression required by GROUP BY clause means exactly that. If you use a GROUP BY then there must be an aggregation expression in the load. You need to add an aggregation expression so that something can be grouped. For example:

           

          load DOC , Sum(PART) as SumOfParts

          from [lib://clinton/Trans.qvd]

          (qvd)

          GROUP BY "DOC"

          ;

          • Re: aggregation prob
            Marcus Malinow

            Hi Jhonatan,

             

            looking at the second LOAD statement, you have a GROUP BY clause, but are not specifying what aggregation you are trying to perform.

             

            LOAD

                DOC,

                minstring(PART) as PART

            from [lib://clinton/Trans.qvd]

            (qvd)

            GROUP BY DOC;

            ;

             

            This would work, but isn't necessarily what you are trying to achieve.

             

            What aggregation are you trying to perform here?

             

            Marcus

            • Re: aggregation prob
              balraj ahlawat

              You are using Group BY:

               

              Two things:

               

              1) It shud be used with aggregate function like sum(),count() etc

              2) It will work on REsident load

               

              Hope this will help!!