2 Replies Latest reply: Feb 20, 2018 3:38 PM by Ishtdeep Singh RSS

    Flagging peek value

    Arpit Kharkia

      Hi all,

       

      I am using Peek() function to flag my peek values. So according to my logic if a values occurs second time in a particular field i flag it as 1. So if A occurs twice the second record is flagged 1, 2 for B, 3 for C and so on.

       

      I need to flag the previous record with the same flag. So the first record of where A occurs should be 1,B will be 2 and so.

       

      What i have

      Field1Flag

      A

      A

      1

      B
      B

      2

       

      What i need

      Field1Flag
      A1
      A1
      B2
      B2

       

       

      Thanks!