combining 2 tables based on productcode that apears inside text in one of the tables

Tue, 21 Dec 2010 12:24:17 GMT

My problem is as follows:

I've got 2 tables:

One table with the orders:

ID	field 2	description
1	xx	bla bla x1 bla
2	yy	bla y2
3	zz	x1
4	aa	x1bla
5	bb	bla bla

and one with productspecifications:

ID	Product	Specification	Discount
p1	x1	dfdf	5%
p2	x2	ghrr	-
p3	y1	tttt	3%
p4	y2	fgd	0
p5	z1	yuu	0

The problem is that I want the 'Specification' en 'Discount' to be matched with the orders, based on the discription in the order table. In the discription the product will sometimes appear inside text. How can this be done?

Gr. Liesbeth

topic combining 2 tables based on productcode that apears inside text in one of the tables in QlikView

combining 2 tables based on productcode that apears inside text in one of the tables