topic Re: Check for a word and identify similar word in QlikView

Check for a word and identify similar word

Anonymous — Fri, 03 Mar 2017 07:16:51 GMT

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

Re: Check for a word and identify similar word

Anonymous — Fri, 03 Mar 2017 07:23:30 GMT

Plz note:

I don't want to use apply map or Comment tables concept.. Bcz in my requirement there are 5 lakh rows and I don't want to manually write MatchCase for all.

I want Qlikview script to dynamically identify similar words. Plz help.

Thanks,

Raghav

Re: Check for a word and identify similar word

Anil_Babu_Samineni — Fri, 03 Mar 2017 07:48:18 GMT

May be this?

LOAD * Inline [

Org. Name, MatchCase

Award, 1

Star, 2

Certificate, 3

Appreciation, 4

Match, 5

];

Concatenate

LOAD If([Org. Name] = Peek([Org. Name],-1), [Org. Name], [Org. Name] & 's') as [Org. Name], MatchCase Resident Sample;

Re: Check for a word and identify similar word

Anonymous — Fri, 03 Mar 2017 07:59:59 GMT

Thank You Anil. Here my concern is not about adding 's' , I meant to say...

Award,

Award is ,

Award is given ,

Award is given to ... should be considered as one and hence MatchCase for this should be same.

Similarly.

Star,

Star is,

Star is in,

Start is in the,.. should be considered as one unit..

Plz help. Thanks.

Re: Check for a word and identify similar word

Anil_Babu_Samineni — Fri, 03 Mar 2017 08:59:44 GMT

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

Anyhow, I followed this. May be use Wild card search. From my input you will get as you expect. I am not sure if i follow wrong

The Search String

Re: Check for a word and identify similar word

kuba_michalik — Fri, 03 Mar 2017 11:28:18 GMT

You could try using WildMatch function to assign MatchCase. Check the attachment for how it could be done for your example data.

Re: Check for a word and identify similar word

Anonymous — Fri, 03 Mar 2017 11:43:16 GMT

hi can yu plz shre script..

Re: Check for a word and identify similar word

kuba_michalik — Fri, 03 Mar 2017 12:05:38 GMT

Sure, here you go.

matches1:
LOAD
  Concat(Chr(39)&[Org. Name] & '*'&Chr(39),',',MatchCase) as match
;
LOAD [Org. Name],
     MatchCase
FROM
[https://community.qlik.com/thread/252021]
(html, codepage is 1250, embedded labels, table is @1);

LET matchCondition = Peek('match',0,'matches1');

DROP Table matches1;

Matched:
LOAD [Org. Name],
     WildMatch([Org. Name],$(matchCondition)) as MatchCase
FROM
[https://community.qlik.com/thread/252021]
(html, codepage is 1250, embedded labels, table is @2);

Re: Check for a word and identify similar word

MarcoWedel — Mon, 06 Mar 2017 01:31:05 GMT

Hi,

maybe helpful to identify Org. Name groups:

tabTemp:
LOAD [Org. Name]
FROM [https://community.qlik.com/thread/252021] (html, codepage is 1252, embedded labels, table is @2);

table1:
LOAD [Org. Name],
     If([Org. Name] like Peek(OrgNamGroup)&'*' and RecNo()>1,Peek(OrgNamGroup),[Org. Name]) as OrgNamGroup
Resident tabTemp
Order By [Org. Name];

DROP Table tabTemp;

hope this helps

regards

Marco

Re: Check for a word and identify similar word

Anonymous — Mon, 06 Mar 2017 05:40:40 GMT

Both are helpful. thank you.

Re: Check for a word and identify similar word

Anonymous — Mon, 06 Mar 2017 05:40:46 GMT

Both are helpful. thank you.

Re: Check for a word and identify similar word

sumitjadhav — Mon, 06 Mar 2017 06:18:39 GMT

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.