joins in qlikview

[Anonymous]

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

];

[anbu1984]

Add space between Inline and [ in the following line

Tab3:

load * Inline [

[#3]

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.

[oscar_ortiz]

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

[anbu1984 · Accepted solution]

If there is no common field, then cartesian product occurs

[#6]

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

[Anonymous]

thanks all,

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

Thanks for your Info