2 Replies Latest reply: Feb 6, 2017 11:12 AM by Stefan Wühl RSS

    Concatenate of multile tables

    Priyanka Pandey

      Hi Team,


      Is it possible to Concatenate multiple tables into 1 table.


      I have Table, Table1, Table2,...Table9 (can increase in future. i.e dynamic numbers of tables)


      So instead of writing


      LOAD * RESIDENT Table; DROP TABLE Table;




      LOAD * RESIDENT [Table1]; DROP TABLE [Table1];


      I want to automate this part..please help/suggest.


      Thanks in advance