Linking tables

[#1]

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

[Gysbert_Wassenaar]

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.

[Anonymous]

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*/];

[#4]

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

[#5]

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

[Gysbert_Wassenaar · Accepted solution]

See attached qvw