6 Replies Latest reply: Sep 22, 2016 8:51 AM by Anshul Narang RSS

    Concatenation

    Anshul Narang

      I am looking for a load script to generate the desired output:

      Input Data

      Column1     Column2

      10               B

      10               A

      20               P

      10               C

      20               R

      10               D

      20               Q

       

       

       

      Output Data

      Column1     Column3

      10               A

      10               AB

      10               ABC

      10               ABCD

      20               P

      20               PQ

      20               PQR

       

      Can someone plz help on this?