Where Exist

[dhavalvyas]

When to use where exist in qlikview scripting.

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

[sunny_talwar]

Help section have some examples:

Exists ‒ QlikView

[sinanozdemir]

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

    A

    B

    C

    D

    E

    F

];

[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

[Frank_Hartmann]

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

[ramasaisaksoft]

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)
;