Question on Concatanate and Where exist ?

[#1]

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;

[maxgro]

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

[#3]

Thanks.

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

[#4]

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

[its_anandrjs]

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.

[maxgro]

yes to the records LOADed from the QVD