Relation with two files

[Constanza]

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 

[rubenmarin]

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...;

[Constanza · Accepted solution]

Hi! 

Many thanks @rubenmarin .

Finally I made it this way: 

LOAD
Cell
FROM [...]

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

Thanks