Loading from different ODBC sources into same table alias (aggregate data)?

[#1]

Hello,

I have 3 separate ODBC sources for my dashboard, each one having roughly the same field names (but not always), but each source is unique to itself. I need to somehow load the rows from all 3 sources into a single table alias in Qlikview so that I can display the data on a chart. In the process I want to make homogenize the incoming data as much as possible so it makes sense.

I wonder if I can do something like this:

//Load from first ODBC source

ODBC CONNECT blah blah Source1;

MyTableAlias:

Load

'Source1' as TypeDescr,

'Source1' & `ID` as UniqueID,

ID,

Name,

Date,

Product;

SQL Select * from Source1Table;

//Load from second ODBC source

ODBC CONNECT blah blah Source2;

MyTableAlias:

Load

'Source2' as TypeDescr,

'Source2' & `ID` as UniqueID,

ID,

TheName as Name,

TheDate as Date,

TheProduct as Product;

SQL Select * from Source2Table;

//Load from third ODBC source

ODBC CONNECT blah blah Source3;

MyTableAlias:

Load

'Source3' as TypeDescr,

'Source3' & `ID` as UniqueID,

ID,

Name as Name,

Date as Date,

aProduct as Product;

SQL Select * from Source3Table;

My main concern is if Qlikview allows this, where I am reusing MyTableAlias 3 times.. I am not sure if doing this appends the data to the alias on each load.

[cesaraccardi · Accepted solution]

Hi,

Regardless of the source QlikView will always concatenate the loads into a single table if they have exactly the same fields (auto concatenation) otherwise you'll have to put the command concatenate just before the secondary loads.

Regards,

Cesar

[#3]

Cesar,

Thank you again for the quick response and thorough answer!