5 Replies Latest reply on Aug 19, 2021 7:06 PM by Mani Ar

    How to repeat values for multiple rows based on a different port

    Mani Ar Seasoned Veteran

      Hi,

       

      I have incoming records with many different columns and I want one of the columns to have the same value repeated based on the first row.

       

      Example given below:

       

      In the Input source records, the channel column has a value only for the first record. I want the same value repeated for the remaining records for the same TranID.

      Here, Tran ID, '1000' has 'LakePark' as Channel for the first record. I want the same channel value to occur for the other TranID = '1000' records too.

      This pattern should repeat for all the TranID records with their respective Channel values.

       

      Input records:

       

       

      TranIDChannelProdID
      UnitPriceQtyLineItemValue
      1000LakePark34545$315$
      100036y77.3$17.3$
      10007y657$214$
      2500Lincolny6i96$16$
      250076543.3$26.6$
      0987FashionCity76901$1010$

       

      Output Records:

       

      TranIDInstanceProdID
      UnitPriceQtyLineItemValue
      1000LakePark34545$315$
      1000LakePark36y77.3$17.3$
      1000LakePark7y657$214$
      2500Lincolny6i96$16$
      2500Lincoln76543.3$26.6$
      0987FashionCity76901$1010$

       

      Please help an Thanks in Advance!

      Mani A