topic Syntax to Join in QlikView

Syntax to Join

Thu, 08 Mar 2012 10:42:56 GMT

I want to join two tables which have a common column name, please tell me syntax for it.

Thanks in advance

Sagar

Re: Syntax to Join

CELAMBARASAN — Thu, 08 Mar 2012 10:47:55 GMT

Hi,

You don't need to join it.Qlikview join it internally.

If you trying to make a single table then use with this.

Inner Join(TableName1)

Load

Resident TableName2;

Note:TableName1 is already loaded table which you need to join.

Hope it helps

Celambarasan

Re: Syntax to Join

jagan — Thu, 08 Mar 2012 11:17:02 GMT

Hi,

You have various types of joins. They are Left, Right, Outer and Inner. You can see the examples of those

Left Join(TableName1)

Load

Resident TableName2;

Right Join(TableName1)

Load

Resident TableName2;

Inner Join(TableName1)

Load

Resident TableName2;

Outer Join(TableName1)

Load

Resident TableName2;

Hope this helps you.

Regards,

jagan.

Re: Syntax to Join

Anonymous — Mon, 27 Jan 2014 13:43:30 GMT

Hi Sagar,

Qlikview Joins tables two ways:

·Auto Concatenate

·Force Concatenate

Auto Concatenate:

1. When QlikView finds multiple tables with the exact same fields, it combines them into one table automatically

2. Create empty fields (dummy fields) using null() function for missing ones in each table

Sales:

Load

Year,

Month,

[Customer Number],

[Sales Amount],

Null() as [Budget Amount]

FROM Sales;

Budget:

Load

Year,

Month,

[Customer Number],

Null() as [Sales Amount],

[Budget Amount]

FROM Budget;

Force Concatenate:

1. Joins two tables with different fields

Sales:

Load

Year,

Month,

[Customer Number],

[Sales Amount],

FROM Sales;

Budget:

Concatenate (Sales)

Load

Year,

Month,

[Customer Number],

[Budget Amount]

FROM Budget;

This post explains joins and concatenate http://community.qlik.com/message/416223#416223

Re: Syntax to Join

Mon, 27 Jan 2014 13:55:32 GMT

Hi,

I have written a doc on LOAD where the JOIN is explained:

http://community.qlik.com/docs/DOC-5698

It should help you.

Fabrice