Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what are uses of where exists and is it work on qvds .pls share with example.
One example is here :Dual & Exists – Useful Functions
Another one: Re: How to exclude specific data in the loading script.
- Marcus
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
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