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

SQL like '%' JOIN in Qlikview

Hello!

I need to link Products and Specific Items with Transactions, but there is one difficulty... Exact match can't be used...

Problem details:

-----------

Products:

Aaa

Bbb

Ccc

----

Specific Items:

A1 (linked with Product "Aaa")

B1 linked with Bbb

B_2 linked with Bbb

Cc1 linked with Bbb

----

Transactions (key, sum):

Aaa-A1; 200

Aaa-A1_1; 250

Bbb-B1;100

Bbb-B_2_9; 50

In SQL it is very simple... WHERE Transaction.key Like (Product.code + '-' + Item.code) OR Transaction.key Like (Product.code + '-' + Item.code +'%[_]_' )

The JOIN in SQL takes 8 minutes. Separate LOADs in Qlikview takes few seconds. But I don't know how link those Transactions with "tail" [8o|]

Any suggestions?

1 Reply
Not applicable
Author

Hi!
You can use wildmatch() where '*' remplace '%' in SQL.