Combining mapping load and wildmatch

prayner — Sun, 24 Sep 2023 20:33:52 GMT

Say I have the following data sample:

ClientID	Transaction	Description
001	1	green leather
001	2	red car
001	3	black sky
002	1	grey shirt

I want to add a new field with information about the client using wildmatching and a mapping table, printed below:

[model]:
LOAD * INLINE
[
pattern, model_name
*leather*, CLOTHING
*sky*, AVIATION
*car*, MOTOR
*shirt*, CLOTHING
];

How can I create the desired output using the mapping table:

ClientID	Transaction	Description	model_name
001	1	green leather	CLOTHING
001	2	red car	MOTOR
001	3	black sky	AVIATION
002	1	grey shirt	CLOTHING

My current solution uses a nested if statement, but it is not a clean solution and is not sustainable long-term when the table gets bigger.

if(WildMatch(Description, '*leather*', '*shirt*'), 'CLOTHING
if(WildMatch(Description, '*sky*'), 'AVIATION',
if(WildMatch(Description, '*car*'), 'MOTOR',
'UNIDENTIFIED'))) as model_name

Re: Combining mapping load and wildmatch

rwunderlich — Sun, 24 Sep 2023 20:37:38 GMT

You can use a table to generate a pick(match()) expression that simulates using wildcards in a mapping table. Download this example for details:

https://qlikviewcookbook.com/list-recipes/#squelch-taas-accordion-shortcode-content-13

-Rob

topic Re: Combining mapping load and wildmatch in App Development

Combining mapping load and wildmatch

Re: Combining mapping load and wildmatch