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