topic Loading data from Multiple Tables in QlikView

Loading data from Multiple Tables

Wed, 14 Apr 2010 14:59:03 GMT

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 — Wed, 14 Apr 2010 15:25:04 GMT

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.