9 Replies Latest reply: Dec 29, 2017 9:34 AM by pradosh thakur RSS

    Compare the currrent row and previous row

    kvp kumar

      Hi friends,

       

      I have below one scenerio

       

      CIDCTypePanid
      1OLDAB123
      2OLDAB124
      3ExistingBC12
      4ExistingCC123
      5ExistingDD12
      6NewBC12
      7NewCC123
      8NewDD1234

      and i want to add the new column as flag below scnerio

      A) if panid is same for both Eixsting Ctype and New Ctype then the flag have as existing .

      B) If Panid is avaliable in Existing Ctype and not avaliable in New Ctype then the flag as Existing.

      C) If Panid is avaliable in New Ctype and not avaliable in Existing then the flag as New

      D) If panid is available in Old Ctype then in these case should not compare and for this flag as OLD

       

      It looks likes as below.

      CIDCTypePanidFlag
      1OLDAB123OLD
      2OLDAB124OLD
      3ExistingBC12Existing
      4ExistingCC123Existing
      5ExistingDD12Existing
      6NewBC12Existing
      7NewCC123Existing
      8New
      DD1234New

       

      And that to i need to create the flag in the scirpt editor and not in the front end. Because based on this i need to implement another scnerio.

      Can any one please help me on this.

       

       

      Thanks

      Kumar KVP