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
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);
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
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;
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.
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
You could try using WildMatch function to assign MatchCase. Check the attachment for how it could be done for your example data.
hi can yu plz shre script..
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);
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
Both are helpful. thank you.