Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking tables

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:

IDProductNameIDElse
1123abc
2456def

Table Product Name:

IDName
123Product 1
456Product 2
1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
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.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand