4 Replies Latest reply: Oct 5, 2016 7:52 PM by Marco Wedel RSS

    Concatenate tables based on defined structure?

    Sharma Sharma

      Hi All,

       

      I have a requirement where i have around 30 tables and i want to concatenate them.

       

      Some of the column in each table are same.. and i want to create a final concatenated table based on defined structure..

       

      For example : suppose i want to create a final table having column names as

      ABCDE

       

      now there are around 30 tables to be concatenate and form the final table.. let me give two table structure...

       

      Table1:

      ACDM
      1111

       

      Table2:

      ABCEMNOP
      22222222

       

      for these two table i can simply restrict table column manually..

       

      But looking for a way where i can use some for loop and some condition to load all the tables but pick only desired columns...

       

      hope i am able to clarify my requirement..

       

      please help and let me know if any further clarification required.