topic Re: Load tables with exact similar structure, avoid double entries in QlikView

Load tables with exact similar structure, avoid double entries

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

Hi All

I want to load two tables into Qlikview with the exact same structure.

However, one table contains data for accounts from Jan 2015 till December 2017. The other table contains data from December 2017 till July 2018. It is not clear whether the first table and the same table contain both all the data from December 2017.

Hence, I would like to load all data from the second table that do not have the same account key/account reference like any account in the first table.

I wanted to use Where not Exists(Key). However, that created the problem that if an account has several rows in the second table, only one row would be loaded.

How can I avoid that the data from December 2017 is loaded twice, but all the data in the second table is loaded?

Many thanks.

Best regards,

Jan

Re: Load tables with exact similar structure, avoid double entries

YoussefBelloum — Wed, 18 Jul 2018 15:27:10 GMT

Hi,

using where not exist(field) will load no rows if the condition is met even if there is several rows in the same table..

Re: Load tables with exact similar structure, avoid double entries

schumi1980 — Wed, 18 Jul 2018 15:32:59 GMT

Yes, but the same happens for accounts in the second table that are not in the first table. I just get one row. I would like to avoid that.

Re: Load tables with exact similar structure, avoid double entries

marcus_sommer — Thu, 19 Jul 2018 12:09:31 GMT

I think you just need to make your key unique maybe by adding the date and/or something like a OrderId to your account-id.

- Marcus

Re: Load tables with exact similar structure, avoid double entries

schumi1980 — Fri, 17 Aug 2018 11:52:01 GMT

I was afraid of that. As there was no other solution I did that.