topic Re: database handling in QlikView

database handling

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a two different servers on which two different database are maintained so i have combined both of them by writing a query in sql and then have pulled columns in Qlikview

Now My question is that when I Pulled the columns I may get duplicate records so now how to handle those duplicate records?

Does qlikview automatically handles those records?

I have even used distinct keyword but that was not working

For eg:-

Select distinct * from abc ;

regards

Saksham

Re: database handling

lanlizgu — Tue, 08 May 2018 10:23:07 GMT

Once you load the data from the two tables you can group the data by the fields you want so you could delete duplicated records.

Re: database handling

Anonymous — Tue, 08 May 2018 10:31:57 GMT

How. Please share the sample?

Re: database handling

Anil_Babu_Samineni — Tue, 08 May 2018 11:15:01 GMT

Yes, If all rows carrying same records, Default Qlik can load only Unique rows which are not getting 2 different values.

Re: database handling

Anonymous — Tue, 08 May 2018 11:23:06 GMT

What if some rows are same and some rows have same primary key but other values are different ?

Re: database handling

lanlizgu — Wed, 09 May 2018 10:25:28 GMT

Hi Saksham,

With a distinct load you are able to avoid loading these duplicated lines.

However, if you want not to show some duplicated lines for specific fields, you can also do a sum based on a fake field and group the fields you would like to avoid duplicated lines.

Please find attached a qvw example with these two examples.