Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
This is a duplicate post. The original thread is here: Is it possible to combine two access databases in one qvw file
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
Thanks and I couldn't able to get the binary load please help me as I need to this in production please!
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.
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 .
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
Please help me how to remove duplicates as this is very urgent for me please I am not getting any idea in doing this.