3 Replies Latest reply: Dec 30, 2015 7:27 AM by Debabrata Das RSS

    Append records with different field names

      Hi Experts,

       

      I want to append records into one table from two different tables, but on my two tables the number of fields and field order arrangement  is same for both. But here field names are different

       

      Note : I cannot change the field names on Table2

       

      Illustration

      Table1

      FieldName1FieldName2FieldName3
      aaa1aaa2aaa3
      bbb1bbb2bbb3

       

      Table2 (with different names - but table structure is same as Table1)

      @1@2@3
      ccc1ccc2ccc3
      ddd1ddd2ddd3

       

      Result

      FieldName1FieldName2FieldName3
      aaa1aaa2aaa3
      bbb1bbb2bbb3
      ccc1ccc2ccc3
      ddd1ddd2

      ddd3