Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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
Partner Ambassador/MVP
Partner Ambassador/MVP

Great. Hope you learned something new. 🙂

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!