6 Replies Latest reply: Jul 17, 2017 1:34 AM by Muhammad Mattiullah RSS

    Error when using group by clause

    Muhammad Mattiullah

      Can anyone tell me why i am getting the error over this query when i am trying to use group by clause in below query.. Kindly suggest me how should i modify this query in order to run it properly.

      Thanks

       

      LOAD

          SLUG,

          TIME,

          HOURS,

          Block,

          COUNT(LIH) as Sums

         

      FROM [lib://Desktop/generate.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      Group BY SLUG;

       

       

      ERROR'S ARE ALSO ATTACHED.