SQL like '%' JOIN in Qlikview

Mon, 17 Jan 2011 17:40:21 GMT

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?

SQL like '%' JOIN in Qlikview

Wed, 20 Apr 2011 14:26:07 GMT

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

topic SQL like '%' JOIN in Qlikview in QlikView

SQL like '%' JOIN in Qlikview

SQL like '%' JOIN in Qlikview