Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

My problem is as follows:

I've got 2 tables:

One table with the orders:

IDfield 2description
1xxbla bla x1 bla
2yybla y2
3zzx1
4aax1bla
5bbbla bla


and one with productspecifications:

IDProductSpecificationDiscount
p1x1dfdf5%
p2x2ghrr-
p3y1tttt3%
p4y2fgd0
p5z1yuu0


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

0 Replies