topic Re: How to get data from two access databases in one qlikview file in QlikView

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

Fri, 10 Jan 2014 14:02:20 GMT

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.

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

fabrice_lawson — Fri, 10 Jan 2014 14:07:35 GMT

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

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

Anonymous — Fri, 10 Jan 2014 14:08:55 GMT

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

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

Nicole-Smith — Fri, 10 Jan 2014 14:09:53 GMT

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

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

Fri, 10 Jan 2014 14:10:57 GMT

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

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

Fri, 10 Jan 2014 14:12:17 GMT

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

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

Anonymous — Fri, 10 Jan 2014 14:14:47 GMT

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.

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

Fri, 10 Jan 2014 14:16:11 GMT

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 .

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

Fri, 10 Jan 2014 14:28:08 GMT

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

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

Fri, 10 Jan 2014 15:40:09 GMT

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

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

Anonymous — Fri, 10 Jan 2014 16:31:20 GMT

I see that your time ranges overlap, hence the duplicates. If time is a reliable criteria, you have to load data from the database ony after the latest date of the database A, for example

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

WHERE Table1Date > '03/06/2013'

;

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

Fri, 10 Jan 2014 17:01:44 GMT

Thanks and when I am giving the date as Date>'03/06/2013' it is showing data type mismatch for date while running the script.

Do I need to change date format?

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

Anonymous — Fri, 10 Jan 2014 21:23:48 GMT

This is the date format you showed in your post... Try to change it to the correct one in the "WHERE".

Usually this helps, it is using whatever format is set in your application (I assume it is March 6, not the June 3):

date(date#('03/06/2013', 'MM/DD/YYYY'))

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

marchoctober — Fri, 10 Jan 2014 21:44:20 GMT

It possibly in data format error. Just experiment with the data in different types and formats, with ' ', without, with date() etc. I beleive if you decopmose every step of your load and every proccess that currently handled with script scenario you will be able to impress your own solution with this load.

As for duplicates, define which how would you use the data model? Do you need to see the rows in separate tables, or in one main containing data from two access databases? Try to draw a model you want to get for your task on paper. And what should you do to get this. And you will do the needed script in action. You can remove duplicates with different ways in QlikView, f.e. as I understand the duplicates are between 01/08/2010 to 03/06/2013? If it is so, just remove in load script just for start with where date < or > or beetween the dates, get the data and improve.

Thanks.

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

marchoctober — Sun, 23 Feb 2014 10:46:16 GMT

Any update? As question not answered.

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

Anonymous — Mon, 24 Feb 2014 13:15:31 GMT

I think that the question has been answered. And a follow-up question has been answered. The only problem that it was not marked as answered