Loading data from Multiple Tables

[#1]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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.