exist function

[qlikview979]

What is exist function ,how to use exist function ?

[petter]

Exist() is used in a Load Script to check if some value already exists in a given field. It returns true if you have a match and false if you don't.

[sunny_talwar]

Please find a snippet from the help section of QlikView if you have not already seen this.

Best,

Sunny

[sunny_talwar · Accepted solution]

Here is an example for you to look at:

Table1:

LOAD * INLINE [

    Number

    1

    2

    3

    5

    7

];

Table2:

LOAD * INLINE [

    Number2

    3

    6

    8

    1

    2

    3

    6

    5

    6

    8

    4

    7

    1

    2

    3

    4

    5

    6

    7

    8

    9

];

Table:

LOAD RowNo() as Key,

  Number2

Resident Table2

Where Exists(Number, Number2);

DROP Tables Table1, Table2;

Output in Table Box object looks like this:

I hope this would be helpful.

Best,

Sunny