Requaried Mapping in bucket using wild search of qlikview

[Rocker]

Hi all,

Needed one help from you.

We hae one Mapping Table like:

Mapping Table:

Bucket        Rules

Fruites       *Mango*,*Apple*,*Banana*,*Orange*

Vagitable   *Onoin*,*Carrot*,*Potato*

Table1:

Values

I eat Mango in summer seasion.

We hae cook Carrot soup today.

Expected Resultant table should be:

Result Table:

Value                                                               Bucket

I eat Mango in summer seasion.          Fruites

We hae cook Carrot soup today.         Vagitable   

This Bucket mapping is required to be change in dynamic basis. There aare lots of bucktes are there i hae puted only tow for sample.

[Kushal_Chawda]

Map:
mapping Load 
lower(trim(subfield(PurgeChar(Rules,'*'),','))) as RuleValues,
'<'&Bucket&'>' as Bucket
Inline [
Bucket,Rules
Fruites,"*Mango*,*Apple*,*Banana*,*Orange*"
Vagitable,"*Onoin*,*Carrot*,*Potato*" ];

Values:
Load *, 
TextBetween(MapSubString('Map', lower(trim(Value))),'<','>') as Bucket 
Inline [
Value
I eat Mango in summer seasion.
We hae cook Carrot soup today. ];

[Brett_Bleess · Accepted solution]

Rocker, did Kush's suggestion work for you?  If so, do not forget to return to your thread and use the Accept as Solution button on Kush's post to give him credit for the assistance with things.  If you are still working upon things, please leave an update post.

Regards,
Brett