topic Re: Exists function in App Development

Exists function

ali_hijazi — Thu, 21 Apr 2022 14:05:01 GMT

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

Re: Exists function

marcus_sommer — Thu, 21 Apr 2022 14:52:04 GMT

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

Re: Exists function

rwunderlich — Thu, 21 Apr 2022 14:53:00 GMT

Yes.

-Rob

Re: Exists function

ali_hijazi — Thu, 21 Apr 2022 15:49:44 GMT

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

Re: Exists function

rwunderlich — Thu, 21 Apr 2022 17:10:22 GMT

Exists(x, y)

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

-Rob