Check for a word and identify similar word

[Anonymous]

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

[Anonymous]

Both are helpful. thank you.

[sumitjadhav]

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.