Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Kindly help me out with below case.
My data is as below.
Org. Name | MatchCase |
Award | 1 |
Star | 2 |
Certificate | 3 |
Appreciation | 4 |
Match | 5 |
My output should be
Org. Name | MatchCase |
Award | 1 |
Awards | 1 |
Star | 2 |
Stars | 2 |
Certificate | 3 |
Certificatee | 3 |
Appreciation | 4 |
Appreciation s | 4 |
Match | 5 |
Match es | 5 |
Here my intension is, qlikview script should treat the similar words(ex: Award/Awards) as same MatchCase. Is there a way to achieve this. Plz help.
Thanks,
Raghav
Both are helpful. thank you.
Hi Ragav,
I had Used Wildmatch To Resolve your issue,Please try the below code,
data:
LOAD [Org. Name] as Name,
MatchCase
FROM
[path);
data2:
load
Name,
if(wildMatch(Name,'Aw*'),1,
if(wildMatch(Name,'S*'),2,
if(wildMatch(Name,'*Certificate'),3,
if(wildMatch(Name,'Ap*'),4,
if(wildMatch(Name,'*Match'),5,))))) as New_case
Resident data;
DROP Table data;
Output is:
Hope that it is helpful.
Thanks & Regards,
Sumit Jadhav.