Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
RD_Nol
Contributor III
Contributor III

WildMatch() Complicated Logic

Hi Community,

 

Hope you all doing Safe.

I've a requirement to match one column values with other column. I tried many ways but till now no luck.

Didn't got any concrete solution for my requirement. @sunny_talwar @tresesco @swuehl @kaushiknsolanki 

Here is my requirement:

Sample Requirement.png

Need your help guys.

Thanks in Advance.

Regards,

Nol

Labels (3)
1 Solution

Accepted Solutions
kaushiknsolanki
MVP & Luminary
MVP & Luminary

Try this using Mapping function. Here is the script.

Mapping:
Mapping LOAD TextBetween(Name&' ',' ',' ') as X,
Name as Y
FROM
[C:\Users\Kaushik\Downloads\Qlikview Requirement Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Data:
LOAD Name,
Details,
MapSubString('Mapping',Details) as [Expected Output],
[Desired Output] as [Output from Excel]
FROM
[C:\Users\Kaushik\Downloads\Qlikview Requirement Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Output as below.

Output.JPG

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

5 Replies
kaushiknsolanki
MVP & Luminary
MVP & Luminary

Try this using Mapping function. Here is the script.

Mapping:
Mapping LOAD TextBetween(Name&' ',' ',' ') as X,
Name as Y
FROM
[C:\Users\Kaushik\Downloads\Qlikview Requirement Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Data:
LOAD Name,
Details,
MapSubString('Mapping',Details) as [Expected Output],
[Desired Output] as [Output from Excel]
FROM
[C:\Users\Kaushik\Downloads\Qlikview Requirement Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Output as below.

Output.JPG

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

RD_Nol
Contributor III
Contributor III
Author

Hi Kaushik,

Thanks again for the Perfect solution. It worked like a Charm.

Pity on me how I missed this. In my mind I was thinking that the string to be kept exactly the same when using Mapsubstring. Text Between and the quotes which you have used did the trick. Wow, it's just amazing.

Thanks again for the quick & optimized solution.

 

Regards.

Nol

kaushiknsolanki
MVP & Luminary
MVP & Luminary

Great. Hope you learned something new. 🙂

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
RD_Nol
Contributor III
Contributor III
Author

Hi Kaushik,

Yes, I'm learning daily some new things. Thanks to you & community.

I've 1 question here. If the Name field has 3 or 4 letter words than this will not work.

or if 2 people have same second name than also it will fail.

example:

1): If the name is John Kennedy Parker than the logic will not work.

2): If the names are: John Hopkins & Ryan Hopkins.

 

In both these cases, the logic will not work. 

Regards,

Nol

kaushiknsolanki
MVP & Luminary
MVP & Luminary

Hi,

You are right, but in that case you need to have some identifier in data to find right match.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".