5 Replies Latest reply on Mar 1, 2021 9:37 AM by Nico Heinze

    one column to multiple

    New Member


      Hi ,

      I have source as



      column



      name1

      name2

      name3

      age1

      age2

      age3

      address1

      address2

      address2



      this is a single column in source with 9 records.



      now my target should be 3 records.



      namecolumn agecolumn addresscolumn



      name1 age1 address1

      name2 age2 address2

      name3 age3 address3





      we do not know how many names ,ages ,address will come in source...

      we have to do this in informatica...no procedures or sql..





      kindly advise...