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

      FINAL:

      LOAD * RESIDENT Table; DROP TABLE Table;

       

      Concatenate

       

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

       

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

       

      Thanks in advance