Complex mapping with keyword

[#1]

Hello everybody,

let me ask your help for an issue I can't solve. Here it is:

I load
table_source:
LABEL,
DATE,
REF

And I have a mapping table
table_map:
KEYWORD,
CATEGORY

I would like to verify for each loaded LABEL if it matches one of the KEYYWORD, and then map it to CATEGORY si oui.

Example:
table_map:
LABEL A,CATEGORY A
LABEL B,CATEGORY B

LIBELLE='HERE IS LABEL B'
woud be mapped to 'CATEGORY B'

I coudn't find any generic formula or loading loop.

Thanks for your help, this forum is always very helpful.

[vgutkovsky · Accepted solution]

Take a look at this post: http://community.qlik.com/message/83844

Regards,

Message was edited by: Jason Long - Updated URL

[#3]

Thank you for this reply. I got to something quite similar on my own this week-end, and this is working well.

Best regards,