topic keep vs exist in QlikView

keep vs exist

Anonymous — Fri, 27 Mar 2015 16:50:56 GMT

keep vs exist

Re: keep vs exist

Sat, 28 Mar 2015 05:34:44 GMT

Can you give clearly about your question ?

I MEAN WHAT DO YOU WANT FROM KEEP VS EXIST?

Re: keep vs exist

Sat, 28 Mar 2015 06:22:07 GMT

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

Where not exist (field name or table name);

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

Re: keep vs exist

robert_mika — Sat, 28 Mar 2015 06:27:27 GMT

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

Re: keep vs exist

krishna20 — Sun, 29 Mar 2015 04:56:25 GMT

Hi,

This may helps you

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

Regards

Krishna