Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am new to qlikview and I need a solution for searching a substring in each sentence.
For example I want to search for a word called DISK from the below sentences:
1. Disk was full.
2. Disk error.
3. Disk space error.
What function can be used to search.Please help.
You didn't say what you wanted to do if the word is found.
This will return the position of the word in the string:
= index(FieldWithSentence,'Disk')
Hi,
You can try with Match, Mixmatch and Wildmatch.
Hi,
You could take Mike Woolf's answer a bit further...
=If(Index(FieldWithSentence,'Disk') >0,'Found','Not Found');
If(sentence like '*Disk*', dosomething, dosomethingelse)
Hi Mike,
What I am trying to get is ,if i use inner join between two tables below
Keyword1 | Keyword2 |
cpu | cpu |
battery | cpufailure |
outlook | battery |
reboot | upsBatteryfailure |
result | emailoutlook |
user | outlook |
reboot | |
rebootdone | |
exchangeoutlook |
I am getting the output as
Keyword |
cpu |
battery |
reboot |
But my expected output is
The words with in the string also should match and give me the output
the output should be like below:
Keyword |
cpu |
cpufailure |
battery |
upsBatteryfailure |
reboot |
rebootdone |
outlook |
exchangeoutlook |
emailoutlook |