Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi!
Many thanks @rubenmarin .
Finally I made it this way:
LOAD
Cell
FROM [...]
LOAD
QueueName as Missingvalue
FROM [...]
Where not exists (Cell,QueueName);
Thanks
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...;
Hi!
Many thanks @rubenmarin .
Finally I made it this way:
LOAD
Cell
FROM [...]
LOAD
QueueName as Missingvalue
FROM [...]
Where not exists (Cell,QueueName);
Thanks