topic Re: Need Help?? in QlikView

Need Help??

Nagaraju_KCS — Fri, 12 Jun 2015 05:41:32 GMT

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....??

Re: Need Help??

jonathandienst — Fri, 12 Jun 2015 05:46:57 GMT

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

Re: Need Help??

Ralf-Narfeldt — Fri, 12 Jun 2015 05:48:39 GMT

What are you trying to achieve?

Re: Need Help??

jagan — Fri, 12 Jun 2015 05:57:07 GMT

Hi,

Check for detailed help in the attached link

Joins and Lookups

Refer The Exists() function section;

Regards,

jagan.

Re: Need Help??

Nagaraju_KCS — Fri, 12 Jun 2015 05:57:08 GMT

HI,

Actually i have developed application, I am supporting side,

I am little confuse, they are used script like,

Re: Need Help??

Ralf-Narfeldt — Fri, 12 Jun 2015 06:02:15 GMT

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

Re: Need Help??

Nagaraju_KCS — Fri, 12 Jun 2015 09:07:13 GMT

Hi Jonathan,

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

PFA,

Re: Need Help??

Anonymous — Fri, 12 Jun 2015 09:21:34 GMT

check the previous table for the stu_num field.

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

Re: Need Help??

sasiparupudi1 — Fri, 12 Jun 2015 11:23:40 GMT

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;