Lookup / Mapping table

Mon, 15 Jun 2015 16:13:04 GMT

Hi,

I am new to Qlik view and have the following question.

I am importing a Excel spreadsheet which has a Description field. In the select statement i am currently using nested IF() statement with the LIKE *Sample* to generate a new field with a group description for example

Description = 'this is January 2015'

,IF(Description like *Jan*,'blue','black') AS Group

Now Qlik has a limit of upto 100 nested IF statements.

Is there a way for me to store the keywords in a table(populated from another spreadsheet) and "Join" onto my main import table ? the trick is that i must still use the LIKE operator or something similar in order to identify each record and assign it to the group from my template.

I hope this makes sense.

thanks

topic Lookup / Mapping table in QlikView

Lookup / Mapping table