@tingtingxia
Yes, you are correct, I thought you were an internal employee because there was an A next to your name.
First thing, it looks like you have Time as part of key, maybe not actually, but your "text" column as Time as part of which will increase the size of your list and cause performance issues. If this is the case, you need to create a truly unique key for your data where your transactional data (data that changes across time periods) gets loaded to a transactional module (dimensionalized by Time) and then the metadata (data about the unique key) gets loaded into a SYS module.
https://community.anaplan.com/t5/Best-Practices/Data-hubs-purpose-and-peak-performance/ta-p/48866
Secondly, I would create a list of the strings you are looking for. For example, if you are looking for:
abc
bcd
efg
The problem with the above is how many strings are you looking for as this will impact the following statements?
Then I would create that as a list. Create a module with those values with the mapping list member associated with that member.
Now, for the text string, you can use the find function, something like this:
Find("abc",text string)>0 which should be formatted as a boolean.
this is the ugly part, you can create a nasty IF then else with a bunch of Finditems(), but there really needs to be another/better way.
once you get the text that you are looking for into a list formatted line item, then you can do a lookup to the mapping module.
Hope this gets you on your way.
... View more