topic [ask] how to join two different tables of qvds into one qvd ? in QlikView

[ask] how to join two different tables of qvds into one qvd ?

Tue, 07 Sep 2010 13:10:27 GMT

hello..

i'm still new in qlikview and need some support

i've made a few of qvds

and i want to join two qvds into 1 qvds

in database statement (example, sql server), i'll easily use :

select a.*, b.*

from tes1 a, tes2 b

where a.field1=b.field2

but how i can do that in edit script of qlikview?

is there any example of file?

i really need helps here..

many many thx...

[ask] how to join two different tables of qvds into one qvd ?

Tue, 07 Sep 2010 13:22:17 GMT

Hi Robert,

The solution is something like this:


FinalTable:
LOAD Field_1 as CommonField,
 Value
FROM file_1.qvd
(qvd);
INNER JOIN
LOAD Field_2 as CommonField,
 Value2
FROM file_2.qvd
(qvd);
store FinalTable into Final.qvd;

I hope it helps you.

Regards.

[ask] how to join two different tables of qvds into one qvd ?

Tue, 07 Sep 2010 13:44:45 GMT

Hi,

You can use it like

LOAD *;

SQL

select a.*, b.*

from tes1 a, tes2 b

where a.field1=b.field2;

This will give you the desired result as it was working in SQL database.

Regards,

Raj Kishor

[ask] how to join two different tables of qvds into one qvd ?

Wed, 08 Sep 2010 03:54:52 GMT

thx miquel it work

but when i try it from 1 table, it doesn't work

i did this :

join_table:

LOAD MST_SAHAM_CODE as kode_saham,

date(TRANS_SAHAM_DATE) as date_saham,

if(isnull(TRANS_SAHAM_VOLUME),0,TRANS_SAHAM_VOLUME) as volume

FROM

(qvd);

left join

LOAD MST_SAHAM_CODE as kode_saham_yest,

date(TRANS_SAHAM_DATE+1) as date_saham,

if(isnull(TRANS_SAHAM_VOLUME),0,TRANS_SAHAM_VOLUME) as volume_yest

FROM

(qvd);

but it got freeze

and an error pop up

why does it happen?

thx..

[ask] how to join two different tables of qvds into one qvd ?

Thu, 09 Sep 2010 12:56:44 GMT

Hi Robert,

I understand you are trying to join your qvds using date_saham field, and that's correct, It should work, could you attach the error message what you get?

Regards.

[ask] how to join two different tables of qvds into one qvd ?

Thu, 09 Sep 2010 14:02:21 GMT

HI Robert,

Just try to change

date(TRANS_SAHAM_DATE+1) as date_saham,

this to new one

date(TRANS_SAHAM_DATE) + 1 as date_saham,

and check.

Hope it should work or attach the error message.

Regards,

Raj Kishor

[ask] how to join two different tables of qvds into one qvd ?

beristardj — Wed, 07 Mar 2012 23:47:42 GMT

Probably the common field in both tables for the nomenclature is a date, they tend to be of real continuous data, whether in whole or chains become probably summarizes the data.

I hope you work ...

[ask] how to join two different tables of qvds into one qvd ?

magavi_framsteg — Thu, 08 Mar 2012 08:55:17 GMT

Hi Robert.

It "could" be that your date fields also have timestamps in them.

So try this (to join only the date part):

date(floor(TRANS_SAHAM_DATE)) as date_shaham

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.