4 Replies Latest reply on Dec 10, 2019 10:57 PM by Harish R

    How To Split Source data columns to different target columns

    Harish R New Member

      Hi,

       

      I have a source a file with below columns. The requirement is to split these columns as different target tables and load the data to the respective tables. Please help... what transformation can I use to get the output?

       

      Input

      Source columns

       

      ID      Name  DOB             Address            Email                      Phone1,               Phone2,       Phone3,         Phone  Type

      123   XYZ     01/01/1987   1 Road street,  name@email.com   111-222-333    222-333-444  444-555-666    Mobile

       

      Outputt

      Target Tables should be:

      Table1:

      ID Name DOB

       

      Table2:

      ID Address

       

      Table3

      ID Email

       

      Table4 : All the phone numbers should get into one column

      ID    Phone    Phone Type

      123 Phone1  Mobile

      123 Phone2  Mobile

      123 Phone3  Mobile

       

      Thanks for your help...

       

      Cheers

      Hari

       

      added input and expected output