Solved: How to get data from two access databases in one q... - Qlik Community

Report Inappropriate Content · ‎2014-01-10

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.

Anonymous · ‎2014-01-10

Amelia,

It may look like this:

Table1:
SQL SELECT
...
FROM table 1;

Table2:
SQL SELECT
...
FROM table 2;

....

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

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

Regards,
Michael

View solution in original post

fabrice_lawson · ‎2014-01-10

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 · ‎2014-01-10

Amelia,

It may look like this:

Table1:
SQL SELECT
...
FROM table 1;

Table2:
SQL SELECT
...
FROM table 2;

....

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

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

Regards,
Michael

Nicole-Smith · ‎2014-01-10

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

Report Inappropriate Content · ‎2014-01-10

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

Report Inappropriate Content · ‎2014-01-10

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

Anonymous · ‎2014-01-10

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.

Report Inappropriate Content · ‎2014-01-10

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 .

Report Inappropriate Content · ‎2014-01-10

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

Report Inappropriate Content · ‎2014-01-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.

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