topic Re: Linking fields using wildcards in QlikView

Linking fields using wildcards

prat1507 — Sat, 16 Nov 2024 05:10:01 GMT

Hi Team

I have two tables with columns Col1 and Col2 respectively. The columns contain value as follows:

Col1:

*apple*

*cat*

Col2

apple1

apple2

apple3

I want to link the two tables on the fields above, is it possible? Please play around in the load script in order to achieve this. Any help would be appreciated.

Regards
Pratyush

Re: Linking fields using wildcards

tresB — Thu, 22 Nov 2018 07:22:55 GMT

Have you tried MapSubString()?

Re: Linking fields using wildcards

vitaliichupryna — Thu, 22 Nov 2018 08:56:12 GMT

Hi Pratyush!

I think you should make mapping with wildcard this solution was developed by Rob Wunderlich , you can find it here:

http://qlikviewcookbook.com/recipes/download-info/mapping-with-wildcards/

You just need put you data in the wildmap table

LOAD * INLINE [
Key, Label
*apple*, 1
*cat*, 2
*dog*, 3
]

And then add Key to both tables as in example below

Table1:
LOAD *, $(vMapExpr(Col1)) as Key
;
LOAD * INLINE [
Col1, Category
*apple*, fruits
*cat*, animals
]
;

Table2:
LOAD *, $(vMapExpr(Col2)) as Key
;
LOAD * INLINE [
Customer, Col2
A, apple1
B, apple2
C, apple3
A, cat1
D, dog1
]

Thanks,

Vitalii

Re: Linking fields using wildcards

prat1507 — Thu, 22 Nov 2018 09:35:22 GMT

Fantastic!! That worked, thanks a lot...... You truly saved my day!

Regards
Pratyush