topic Re: Where Exist in QlikView

Where Exist

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

When to use where exist in qlikview scripting.

can i get solution proper solution with its raw data and qvw ??

Re: Where Exist

sunny_talwar — Fri, 12 May 2017 18:00:56 GMT

Help section have some examples:

Exists ‒ QlikView

Re: Where Exist

sinanozdemir — Fri, 12 May 2017 18:57:02 GMT

Hi,

In a nutshell, you can determine which records should be loaded into the memory based on a previously defined table(s). See the below example:

[Table 1]:

LOAD * INLINE [

Names

];

[Table 2]:

LOAD * Where Exists(Names);

LOAD * INLINE [

Names, ID

A, 1

R, 23

T, 45

C, 3

F, 5

];

In this case, only "A", "C", "F" will be loaded from Table 2

Re: Where Exist

Frank_Hartmann — Fri, 12 May 2017 20:19:07 GMT

Note:

Exists() can be used with one argument, a field name,

then it checks the current field value against the loaded field values so far.

If you use Exists() with two arguments, first denotes the field / symbol table to check, second denotes an expression that creates the values you want to check. You would need this when you are building a key field that does not exists in your input table, only in your output table.

hope this helps

Re: Where Exist

ramasaisaksoft — Sat, 13 May 2017 12:00:57 GMT

Hi Dhaval,

You can use following code as an example else pls upload your requirement with sample data.

History:
Load Order_No,

Price_Value
from Sales.qvd(Qvd)

;

Load Order_No,

Sale_Value

from Order.qvd(Qvd)

where exists(Order_No, Order_No)
;