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

Fri, 20 Jul 2012 16:31:27 GMT

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.

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

cesaraccardi — Fri, 20 Jul 2012 18:43:21 GMT

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

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

Fri, 20 Jul 2012 19:26:50 GMT

Cesar,

Thank you again for the quick response and thorough answer!

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

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

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

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