4 Replies Latest reply: Aug 8, 2016 5:36 AM by Sunny Talwar RSS

    Add max of 1 field another another field

    Swati Tomar

      Hi Everyone.

       

      I am Stuck at one point in Scripting..

      Want to merge two field but issue is this max of one field on the basis of group with another field.

       

      WHat I did:

      In OLD QVD: I have group and old_grp and IN NEW QVD I have group and new_grp

      I concatenate both the QVD but I didn't the Output as I want.

       

      Example

      OLD QVD

      Groupold_grp
      123201401
      123201402
      123201403
      123201404
      123201405
      124201501
      124201502
      124

      201503

       

      NEW QVD

      Groupold_grp
      123201401
      123201402
      123201403
      124201501
      124

      201502

       

      OUTPUT as I want

      Groupold_grp
      123201401
      123201402
      123201403
      123201404
      123201405
      123201406
      123201407
      123201408
      124201501
      124201502
      124

      201503

      124201504
      124201505

      Please help me out..

       

      Regards

      Swati