topic Re: Relation with two files in QlikView

Relation with two files

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

Hi everyone,

Please your help. I have two excel files that are communicated by one variable. One of them is always adding information and the other one is a type of dictionary. My idea is to look if in this files that are upload everyday, the variables are all included in my “dictionary”.

example.
The loaded files contains the values A, B, C, D. But the dictionary only have the values A, B.
I want to show that values C and D are missing in my dictionary file and must be included.

Do you have any idea on how to do this exercise?
Thanks in advance

Constanza

Re: Relation with two files

rubenmarin — Thu, 09 Jul 2020 06:49:53 GMT

Hi, you can load all files from dictionary and check the missing values loading the other file using Exists()

Dictionary: LOAd Value From...; OtherFile: LOAD If(not Exists(Value), Value) as MissingValue, VAlue From...;

Re: Relation with two files

Constanza — Thu, 09 Jul 2020 14:42:19 GMT

Hi!

Many thanks @rubenmarin .

Finally I made it this way:

LOAD
Cell
FROM [...]

LOAD
QueueName as Missingvalue
FROM [...]
Where not exists (Cell,QueueName);

Thanks