Join

[Anonymous]

Hi,

I am learning Qlikview and I have a basic doubt abot Join.

I have two tables which are 20 columns in common. I want to make join for this two tables.

In database it is inner join between two tables. If I want to achieve the same should I use Inner Join between two tables. Or simply

like

Load * from table1;

load * from table2;

Regards,

Kumar

[Anonymous]

If I comment same columns in one of the table is also fine.

[sunny_talwar]

Yes, it should be.

Table1:

LOAD AutoNumber(Field1&'|'&Field2&'|'&Field3.....) as Key

Field1

Field2

Inner Join (Table1)

LOAD AutoNumber(Field1&'|'&Field2&'|'&Field3.....) as Key

[Anonymous]

After commenting common columns fields except one key field, is it required to concatenate common columns Sunny?

[#5]

Qlikview will perform Join like in database sql queries. The other option in Qlikview is Concatenate and it works like UNION in SQL.

Based on your requirement you can use Join or concatenate. Before take which operation need to perform, you need to understand the tables relation with respect to your business. If two tables have fact then you can simply concatenate. One table is Fact & other table is Dimension table I would recommend Join.