Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Join between two tables on common key

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?

3 Replies

Re: Join between two tables on common key

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
Valued Contributor II

Re: Join between two tables on common key

Hi,

I will suggest using MAP or ApplyMap function.

Hope this helps.

Gabriel

Not applicable

Re: Join between two tables on common key

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

Community Browser