Need Help??

[qv_testing]

Hi Community,

I have one table like,

Load *, Stu_Num & ID as Key

weere Exists(Stu_Num);

Load ID,

        Stu_Num,

        Name,

        Designation

From Table_Name;

Here, what is the use of Exists() Function??

Please anyone can Explain....??

[jonathandienst]

This is an odd use of Exists(), my guess would be that it does.... nothing. Except possibly excluding any null values in Stu_Num.

[Ralf-Narfeldt]

What are you trying to achieve?

[jagan]

Hi,

Check for detailed help in the attached link

Joins and Lookups

Refer The Exists() function section;

Regards,

jagan.

[qv_testing]

HI,

Actually i have developed application, I am supporting side,

I am little confuse, they are used script like,

[Ralf-Narfeldt]

As Jonathan said it could possibly exclude null values, but I would do that in a resident load instead.

[qv_testing]

Hi Jonathan,

I am Little Confusion, If i am using Exists(ID)  i am not getting records.

PFA,

[Anonymous]

check the previous table for the stu_num field.

This exists will load only the stu_num loaded from the previous table

[sasiparupudi1]

Hi

Use it in the following way

Test:

LOAD id,

     date,

     cost

FROM

(qvd);

Test1:

LOAD *, id & date as ID1 Resident Test

Where Exists(id);

DROP Table Test;