topic Re: Linking tables in QlikView

Linking tables

Wed, 02 Apr 2014 14:05:53 GMT

I have two tables "Product" and "Product Name" at first I keep ProductNameID and other fields, in the second I keep only the name and ID. How to do that in the "Product" to display the name of the table "product name"

Table Product:

ID	ProductNameID	Else
1	123	abc
2	456	def

Table Product Name:

ID	Name
123	Product 1
456	Product 2

Re: Linking tables

Gysbert_Wassenaar — Wed, 02 Apr 2014 14:08:35 GMT

The tables will be linked by ID since both tables have that field. But you probably want to rename the ID field from the second table to ProductNameID. In the front end you can create chart objects like a table box and use the Name field to show the Name of the product that belongs to the ID.

Re: Linking tables

Anonymous — Wed, 02 Apr 2014 14:08:47 GMT

use applymap. something like below in your script:

mappingtable:

mapping load ID, Name from [Product 1 table file];

ProductTable:

Load

ID,

applymap('mappingtable', ProductNameID) as ProductName,

etc.

from [/*your file name*/];

Re: Linking tables

Wed, 02 Apr 2014 14:11:08 GMT

Hi Pawel,

You should just change the "ID" Column name in the "Table Producto Name" for "ProductNameID" that you use in the "Table Product".

Remember that Qlikview links tables automatically when one column name is exactly the same in different tables.

Ryuma

Re: Linking tables

Wed, 02 Apr 2014 14:11:43 GMT

Can I ask for an example in *.qvw, just starting the adventure with QlikView

Re: Re: Linking tables

Gysbert_Wassenaar — Wed, 02 Apr 2014 14:16:56 GMT

See attached qvw