Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Exists function

Hello
I have a question regarding the Exists function
Actually I know how it works; but I always used it in the where condition of a load statement;
the question is:
Can I use the exists function in the load statement as follows?

Table_1:
Load
    Field1
from QvdFile;

Table_2:
Load 
    Field3,
    if(Exists(Field1, Field3), 'Yes', 'No) as Flag

from QvdFile2;

kindly advise

 

I can walk on water when it freezes
Labels (1)
4 Replies
marcus_sommer

Yes, it's applicable in this way. Be aware that only already loaded field-values will be checked regardless from which load-statements and their context.

- Marcus

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes.

-Rob

ali_hijazi
Partner - Master II
Partner - Master II
Author

Regardless from which load you mean the load statements before the current one

I can walk on water when it freezes
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Exists(x, y) 

considers all values of field x that currently exist, which includes values created by current and previous load statements. 

-Rob