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|]