what are uses of where exists

[krishna789]

what are uses of where exists and is it  work on qvds  .pls share with example.

[tresesco]

One example is here :Dual & Exists – Useful Functions

[marcus_sommer]

Another one: Re: How to exclude specific data in the loading script.

- Marcus

[nagarjuna_kotha]

Here is the example for your question:

Let us assume the below data:

Temp:

LOAD * INLINE [

    Name

    A

];

Data:

LOAD * INLINE [

    Product, Name, Sales

    Product1 , A, 673

    Product2, B, 676

    Product3, C, 679

    Product4, A, 682

    Product5, B, 685

    Product6, C, 688

    Product7, A, 691

    Product8, B, 694

] Where Exists (Name);

I have data table, in that i want to load only some specific value from that , in that case i will create one more table with name field wthich i want ion main table and then i ll use where exists function.

I hope you understood.

-Nagarjun

[beck_bakytbek]

Hi Krishna,

The Where is a basic part of scripting-area in QlikView,

look at this: https://www.youtube.com/watch?v=HlBhp29gJIw

i hope that helps

beck