topic Re: Join between two tables on common key in QlikView

Join between two tables on common key

Fri, 10 Aug 2012 13:01:12 GMT

Hi,

I have two tables in below format

TableA:

Load * Inline

[

SR No,Name, City

1,A,C

2,B,D

]

TableB:

Load * Inline

[ No,Full Name, Occupation,salary per month

1,A,EE,10000

2,B,DDDDD,20000

]

How to join these two tables as you can see common key name is diffrent in both tables, Name and fullname.

I don't want to rename my field of Full Name to Name.

In sqls against any relational data base we can compare two columns irrespective of their column name. Is it possible in QLikview?

Re: Join between two tables on common key

Nicole-Smith — Fri, 10 Aug 2012 13:23:17 GMT

The fields must be named the same in order to link them.

To get around the renaming, you could just load one column twice.

For example:

TableA:

Load * Inline

[

SR No,Name, City

1,A,C

2,B,D

]

TableB:

Load * Inline

[ No,Full Name, Occupation,salary per month

1,A,EE,10000

2,B,DDDDD,20000

]

Inner Join (TableB)

LOAD *,

[Full Name] as Name

RESIDENT TableB;

This will keep FullName named as it is in TableB, but it will also add a new field to TableB named Name that will link to TableA.

Re: Join between two tables on common key

Gabriel — Wed, 15 Aug 2012 13:52:39 GMT

Hi,

I will suggest using MAP or ApplyMap function.

Hope this helps.

Gabriel

Re: Join between two tables on common key

Thu, 16 Aug 2012 06:16:03 GMT

You can try as suggested by Nicole that will work out!