topic How to join two tables? in QlikView

How to join two tables?

Wed, 22 Feb 2012 06:46:08 GMT

Hi All,

I am new to QlikView, Can you please help me how to join tables which have different field names. Source data is qvd files I know it can be done by alias. And if those tables have more than two same columns QlikView gives more than two joins, but I am looking for manually join with one joining condition.

How can I join manually?

I know QlikView can join automatically when table field names are same.

Data is like:

Table A

Field1, Field2

10, abc

Table B

Field3, Field4

10, xyz

In this scenario I have to join Field1 and Field3 without using alias.

How to join two tables?

CELAMBARASAN — Wed, 22 Feb 2012 06:56:57 GMT

Hi,

Are you looking for a solution to avoid synthetic key?

Linking 2 tables without same column is not possible in Qlikview.

If you have more than one column as same in two tables then you can use this.

Table1:

Load

Field1 & Field2 as Key,

Field1,

Field2,

Field3

From..

Table2:

Load

Field1 & Field2 as Key,

Field4

From..\\No need to include the fields that forms key in this table

Or Try to make two table as one.

Hope it helps

Celambarasan

How to join two tables?

Wed, 22 Feb 2012 07:20:40 GMT

Hi,

Thanks for reply...

Same field names have different tables.

Data is like:

Table1:

Field1, Field2, Field3, Field4

Table2:

Field2, Field4, Field5

In this scenario QlikView gives two joins:

Table1.Field2= Table2.Field2 and

Table1.Field4= Table2.Field4

But I have to join Table1.Field2= Table2.Field2 only, and these are qvd files.

How to join two tables?

CELAMBARASAN — Wed, 22 Feb 2012 07:24:11 GMT

Hi,

Then use Qualify keyword to solve this.

Table1:

Load

Field1, Field2, Field3, Field4

From QvdFile;

Qualify Field4;

Table2:

Load

Field2, Field4, Field5

From QvdFile;

Hope it helps

Celambarasan