Smart mapping with key words

Fri, 25 Sep 2009 02:20:47 GMT

Hi Qliks

I have a large transaction table with a rather heterogenous transaction text. The thing is, that the transaction text most often contains a single keyword that I want to use for classification.

Note:

I want the entire transaction text to be replaced by the keyword
I will end with a large set of key words
New versions of tranaction texts will appear continously so using apply map is not the right solution since this exercise will never end

Can I avoid generating a long list of key words in the script using e.g. the index function. I would very much like to go for a solution where I could use a key table for the classification since I could then allow my data owners to maintain only that table.

KeyWords:

LOAD * INLINE [

Group

case1

case2

case3

]

;

trans:

LOAD * INLINE [

Trans_text, Amount

abc case2 34, 23

testcase2 345, 66

div case3 345665, 88

case1 898, 7

case1, 889

]

;

I hope that some of you guys can think of a smart dynamic routine - how about reading the "trans" table continously for every key word?!

Regards,

Lars Madsen

topic Smart mapping with key words in QlikView

Smart mapping with key words