keep vs exist

[Anonymous]

keep vs exist

[#2]

hi

Can you give clearly about your question ?

I MEAN WHAT DO YOU WANT FROM KEEP VS EXIST?

[#3]

Hi,

keep is used before load script like this.

Ex:-

     Keep(Bookmark)

    LOAD Id,

    Name,

    UtcModifyTime,

exist is used for WHERE  function.

Ex:-  In Scripting after upload the source data in qlik view,

       Where exist (field name or table name);

                   or

       Where not exist (field name or table name);

                  or

      Where Table name <> 'field name1' and Table name <>  'field name2';

[robert_mika]

In ABC form:

Keep - jafter reload 2 tables

Exist - after reload 1 Table

Extended version:

Keep is used in load statement.

Let say you have two tables with the same name

't1' in two different data sources

Book 1	Book 2

When you use keep Qlikview will leave T1 and t2 tables separately

Data Model

t1:

LOAD Cat,

     Numer

FROM

Book1.xlsx

(ooxml, embedded labels, table is Tab1);

left keep (t1)

t1:

LOAD Cat,

     Numer

FROM

Book2.xlsx

(ooxml, embedded labels, table is Tab1);

Exist can be used in load script and as expression

It will merge both of the table leaving only one table

t1:

LOAD Cat,

     Numer

FROM

Book1.xlsx

(ooxml, embedded labels, table is Tab1);

Directory;

LOAD Cat,

     Numer

FROM

Book2.xlsx

(ooxml, embedded labels, table is Tab1)

where exists (t1, Cat);

[krishna20]

Hi,

This may helps you

http://community.qlik.com/message/32305#32305

Regards

Krishna