topic Re: Question on Concatanate and Where exist ? in QlikView

Question on Concatanate and Where exist ?

Thu, 29 May 2014 17:24:51 GMT

Hi All,

I am new to qlickview.

I have below questions.

Example :

Table:

SQL Select *,PK from DB TABLE

where modificationtime >= lasttime;

CONCATENATE

LOAD *,PK from QVD

WHERE EXIST (PK) <---does this apply to QVD file ? or does it apply to DB Table and QVD File ?

INNER JOIN <---does this apply inner join to QVD File ? or does it apply to DB Table also ?

SQL SELECT

PK from DB Table;

Re: Question on Concatanate and Where exist ?

maxgro — Thu, 29 May 2014 17:33:10 GMT

WHERE EXIST (PK)

returns -1 (true) if the value of the field PK the current record already exists in any previously read record containing that field

copied from online help

INNER JOIN

apply to the qlikview table Table

as you have db and qvd (because of concatenate) in Table, it apply to DB and QVD

Re: Question on Concatanate and Where exist ?

Thu, 29 May 2014 17:38:15 GMT

Thanks.

so, Where Exist cirteria , does it apply to Load Statement after CONCTENATE ?

Re: Question on Concatanate and Where exist ?

Thu, 29 May 2014 17:39:12 GMT

to make easy the way you make your script ...put the information like this

Name_table:

Load

from

where(filters )

;

SQL

Select

from Table

(make all the clauses that you need );

Store Name_table into xyz.qvd (qvd);

Re: Question on Concatanate and Where exist ?

its_anandrjs — Thu, 29 May 2014 17:42:28 GMT

WHERE EXIST (PK)

This will check in the Upper table and as well as in the current table the records PK exits or not

INNER JOIN

This will apply for both tables also and check the records available on both tables or not.

Re: Question on Concatanate and Where exist ?

maxgro — Thu, 29 May 2014 18:58:15 GMT

yes to the records LOADed from the QVD