6 Replies Latest reply: Oct 4, 2013 7:26 AM by Yuri Nicolett RSS

    Merging tables with different fields

      Hi,

       

      I have two fields as below:

       

      NameValue
      Agreement_No0000005238;ABC;123
      Agreement_Desc0000001234;PQR;456
      Agreement_Amt0000009876;XYZ;789

       

      the first field is Descriptions and the second field is values.

       

      I have separated descriptions to a separate table as below using script

       

      Agreement_NoAgreement_DescAgreement_Amt
      1--
      -2-
      --3

       

      I have separated values to a separate table  as below using script

       

      field 1field 2field 3
      0000005238ABC123
      0000001234PQR456
      0000009876XYZ789

       

      Now, my final output should be as below. How can i achieve this?

       

      I have tried using Concatenate but that does not help.

       

      Agreement_NoAgreement_DescAgreement_Amt
      0000005238ABC123
      0000001234PQR456
      0000009876XYZ789

       

      Regards,

      Vishal