Generic Load Joining

    Hi,

     

    Transforming below table into the desired output table in script using Generic load.

     

    Input data:

    IDCategories
    1Car
    2Car|Bike
    3Car|Bike|Boat
    4Car|Bike|Boat|Plane

     

    Desired Output:

    ID1234
    1Car
    2CarBike
    3CarBikeBoat
    4CarBikeBoatPlane

     

     

     

    Regards,

    Celambarasan