8 Replies Latest reply: Dec 5, 2014 5:52 AM by Jan Heinrichsdorff RSS

    Resident statement + Group by

      Hi experts

       

      I have the following resident statement:

      Load

      jobnr,

      max(txtnr) as txtnrMax

      resident Notiz GROUP BY jobnr;

       

      I would like to add another field let#s call it "x" which contains text. Since with the group by function the fields need a max, min eg, I do not know how to include my field that contains text.

       

      Anybody know a solution to this problem?

       

      Best

       

      Jan