How to join two tables?

[#1]

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.

[CELAMBARASAN]

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

[#3]

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.

[CELAMBARASAN]

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