Exists function

[ali_hijazi]

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

[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]

Yes.

-Rob

[ali_hijazi]

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

[rwunderlich]

Exists(x, y) 

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

-Rob