4 Replies Latest reply: Apr 4, 2017 2:56 AM by Arpit Kharkia RSS

    Flag duplicate values

    Arpit Kharkia

      Hi all,

       

      I have the following key

       

      Memo
      123
      124
      125
      123

       

       

      I want a flag depending on the occurrence of the record in the field

       

      MemoFlag
      1231
      1241
      1251

      123

      2

       

       

      if memo 123 repeats again 3 should come and so on. Finally I want to concatenate Memo and Flag.

       

      Memo Key
      1231
      1241
      1251
      1232

       

       

      Thanks!