3 Replies Latest reply: Aug 24, 2012 10:30 AM by Christoph Goertz RSS

    Group by - Syntax error in the code?

    Christoph Goertz

      Hi,

      I have a syntax error in the code. But unfortunately I can not find the error.

       

      Product:

      LOAD * INLINE [

          ID, Artikel

          1, Tee

          2, Milk

          3, Butter

          4, Corn

          5, Burger

          6, Ham

          7, Salt

          7, Salat

          9, Pasta

          8, Cake

          9, Apple

          10, Ice

          9, Water

      ];

       

      LOAD

             ID,

             Count(ID) AS NumOccures

      Resident Product where Count(ID)>=2 Group by ID;

       

      Any hints?

      Many Thx

      Christoph