How to set a new dimension in script based on string search
Hi All,
I cant find any hint to the below, please could you help?
FACTS:
- I have .csv files that I load to QV
- those files have the same structure, different data
- among the dimensions loaded, there is one called "Transaction text". It contains a string expression (mainly letters)
PROBLEM:
1. I need to separate certain type of the transactions from all the rest (one transaction = one record or row in .csv file)
2. All of those that I need to separate contain "rebill" word in the "Transaction Text" string. None of those that I don't need to separate contains this word
3. My idea was to create a new dimension in the script, containing "YES" in case of all records having "rebill" in the "Transaction text" sting, and "NO" for all the rest
How to write a proper function in the script, doing the job?
