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



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








      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.