Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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. ];
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