Join between two tables on common key

[#1]

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?

[Nicole-Smith]

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.

[Gabriel]

Hi,

I will suggest using MAP or ApplyMap function.

Hope this helps.

Gabriel

[#4]

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