1 Reply Latest reply: Apr 14, 2010 11:25 AM by Miguel Angel Baeyens de Arce RSS

    Loading data from Multiple Tables

      Hi,

      I am loading the same data fields from 4 tables (each representing the current and last 3 years)

      Is there a way of scripting this so that I do not need four seperate load statements,

      My first thought was to use AND after the first FROM statement but this does not seem to work.

       

       

       

       



       

       



        • Loading data from Multiple Tables
          Miguel Angel Baeyens de Arce

          Hello Les,

          You can use a for/do while loop to load all four files in the same table, but should the tables are the same (same fields), you can do somethink like

          Table: LOAD * FROM File1; CONCATENATE LOAD * FROM File2; CONCATENATE LOAD * FROM File3;
          unless you need to change your fieldnames. Thus you will have all four files into one table, same fields to operate.

          Regards.