topic how to create a join among 4 qvds? in QlikView

how to create a join among 4 qvds?

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to achieve this

//sql

select

table_1.a,

table_2.b,

table_3.c,

table_4.e

from table_1, table_2, table_3, table_4

where

table_1.p = table_2.p and

table _2.q = table _3.q and

table _3.r = table _1.r and

table_4.s = table_2.s

I know a way to achieve this qlikview using tables but I want to achieve this using qvds as the data is huge.

Re: how to create a join among 4 qvds?

Siva_Sankar — Thu, 06 Jul 2017 02:00:31 GMT

Hi Urmil,

QVD is just storage of data in tabular format, so there is no change in syntax of joining table vs joining qvd.

Example:

Table:

Load

From abc.qvd (qvd);

Left Join Load

From def.qvd (qvd);

Depending on the join that you want to perform, you can replace the join key word(LEFT,RIGHT...,)

-Siva

Re: how to create a join among 4 qvds?

jmvilaplanap — Thu, 06 Jul 2017 09:15:42 GMT

It depends what do you want to do, but first of all, the key fields (to do the join) must to have the same name. And second, depends do you want to do. Automatically, this four tables will be linked by Qlik (associative logic) but if you need yo make joins (and to have one single table at the end), you will have several options

Left Join
Right Join
Inner Join
Outher Join

Here do you have an example: Understanding Join, Keep and Concatenate