topic Re: joins in qlikview in QlikView

joins in qlikview

Anonymous — Tue, 18 Nov 2014 16:41:46 GMT

Hi I am trying the below scenario but i am getting errors .Applying left join on two tables where column names and values are not same .

Tab3:

load * Inline[

num,Data

1,A

2,B

3,C

4,D

];

left join(Tab3)

tab4:

load * Inline [

num1,Data2

10,z

11,x

12,w

13,u

20,s

];

Re: joins in qlikview

anbu1984 — Tue, 18 Nov 2014 16:50:33 GMT

Add space between Inline and [ in the following line

Tab3:

load * Inline [

Re: joins in qlikview

Tue, 18 Nov 2014 17:01:14 GMT

Hi,

There should be some common field in two tables to let join work. Thus suggest you to use one common field(Header) in two table then try.

Otherwise script looks fine to me apart from "Inline [" change.

Re: joins in qlikview

oscar_ortiz — Tue, 18 Nov 2014 17:03:57 GMT

Anbu is correct. Just be aware of what you are actually doing here. You are creating a Cartesian join. This may be what you are looking to do and if so be aware of the implacations. If not you need to rethink what you are actually trying to accomplish.

Good luck

Oscar

Re: joins in qlikview

anbu1984 — Tue, 18 Nov 2014 17:04:10 GMT

If there is no common field, then cartesian product occurs

Re: joins in qlikview

Tue, 18 Nov 2014 18:32:13 GMT

oh Yes , just now I checked. Thanks for the info 🙂

Re: joins in qlikview

Anonymous — Wed, 19 Nov 2014 05:08:36 GMT

thanks all,

I would like to know the reason behind this .I know i am joining very uncommon fields .

Thanks for your Info