3 Replies Latest reply: Nov 14, 2016 10:45 AM by Joanna Seldon RSS

    restart autonumber qlik sense

    Joanna Seldon


      Hi

       

      each CustomerID  has number of OrderID

       

      This order id can look like this x11533322

       

      I wish to autonumber these, but restart the autonumber per customer

       

      I have tried to use in the load

       

      AutoNumber( CustomerID & '|' & OrderID ) as ID

       

      AutoNumber( OrderID ) as ID

       

       

       

       

      I wish for the output to show as

       

       

      CustomerID - ID

       

      A                     1

      A                     2

      A                     3

      A                     4

      B                     1

      B                     2

      B                     3

       

       

       

      Please help