Discussion board where members can get started with QlikView.
I want to join two tables which have a common column name, please tell me syntax for it.
Thanks in advance
You don't need to join it.Qlikview join it internally.
If you trying to make a single table then use with this.
Note:TableName1 is already loaded table which you need to join.
Hope it helps
You have various types of joins. They are Left, Right, Outer and Inner. You can see the examples of those
Hope this helps you.
Qlikview Joins tables two ways:
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
Null() as [Budget Amount]
Null() as [Sales Amount],
1. Joins two tables with different fields
This post explains joins and concatenate http://community.qlik.com/message/416223#416223
I have written a doc on LOAD where the JOIN is explained:
It should help you.