1 Reply Latest reply on Jul 7, 2021 8:39 AM by Tony Coco

    How can I clone a row?

    Tony Coco New Member

      How do I create a clone/copy of all records in a given stream?

       

      Simple example below. I have 2 records in a given table/file/etc.

       

      Col1     Col2     isCloneRow

      1       Testa    0

      2       Testb  0

       

      I would like to get 4 rows back, the original 2 and the copy/clone of the 2 with the isCloneRow flag set accordingly. Effectively, the reverse of deduplication.

       

      Col1     Col2     isCloneRow

      1       Testa    0

      2       Testb  0

      1       Testa    1

      2       Testb  1

       

      If familiar with Pentaho / Hitachi Vantara, they have a "Clone Row" step that does this for you.

       

      Thanks,

      Tony