Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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..
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.
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
I was afraid of that. As there was no other solution I did that.