topic Complex mapping with keyword in QlikView

Complex mapping with keyword

Fri, 15 Oct 2010 19:40:21 GMT

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.

Re: Complex mapping with keyword

vgutkovsky — Fri, 15 Oct 2010 19:45:17 GMT

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

Regards,

Message was edited by: Jason Long - Updated URL

Complex mapping with keyword

Mon, 18 Oct 2010 08:08:48 GMT

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

Best regards,