How to get data from two access databases in one qlikview file

[#1]

Hi,

I have two databases  A and B

A contains data from 01/08/2008 to 03/06/2013

B contains data from 01/08/2010 to till date

Both database contains same tables and same columns when I am trying to reload in one file it is showing data only in A database file.

Please could anyone help me how to set this please

Thanks.

[fabrice_lawson]

if the tables and the columns have the same name/label this will auto concatenate.

to avoid this you could add to NoConcatenate to the load sats

Load A,B from file1.csv;

noconcatenate load A,B from file2.csv;

read more about this in the manual or help ile of QlikView

[Anonymous · Accepted solution]

Amelia,

It may look like this:

<connect to database 1>

Table1:
SQL SELECT
...
FROM table 1;

Table2:
SQL SELECT
...
FROM table 2;

....

<connect to database 2>

CONCATENATE (Table1)
SQL SELECT
...
FROM table 1;

CONCATENATE (Table2)
SQL SELECT
...
FROM table 2;

Regards,
Michael

[Nicole-Smith]

This is a duplicate post.  The original thread is here: Is it possible to combine two access databases in one qvw file

[#5]

Thanks and how can I get Master Calendar when I use this and also I used concatenate but still showing same result. Please help me

[#6]

Thanks and I couldn't able to get the binary load please help me as I need to this in production please!

[Anonymous]

Why is a problem with the master calendar?

I'd create the calendar from 1/1/2008 (start of the year of the earliest data) to the end of the current year.  Prefer always have full years, unless there is a good reason against it.

[#8]

Thanks and I sued the same still it's showing somehow same result  Please do help me is there anything I need to change. And also How can I remove DUPLICATES as I am getting DUPLICATES .

[#9]

Para la segunda tabla , agrega un nuevo campo ejemplo

Tabla 1:
SQL SELECT
...
FROM tabla 1;

Tabla 2:

LOAD

*,

1 as NuevoCampo

;
SQL SELECT
...
FROM tabla 2;

Con esto crearas una segunda tabla con campos direferentes a la primera.

Suerte

[#10]

Please help me how to remove duplicates as this is very urgent for me please I am not getting any idea in doing this.