topic Re: WildMatch() Complicated Logic in QlikView

WildMatch() Complicated Logic

RD_Nol — Sat, 16 Nov 2024 00:50:41 GMT

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 @tresB @swuehl @kaushiknsolanki

Here is my requirement:

Need your help guys.

Thanks in Advance.

Regards,

Nol

Re: WildMatch() Complicated Logic

kaushiknsolanki — Wed, 15 Apr 2020 03:26:20 GMT

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.

Re: WildMatch() Complicated Logic

RD_Nol — Wed, 15 Apr 2020 05:26:55 GMT

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

Re: WildMatch() Complicated Logic

kaushiknsolanki — Wed, 15 Apr 2020 10:30:13 GMT

Great. Hope you learned something new. 🙂

Re: WildMatch() Complicated Logic

RD_Nol — Wed, 15 Apr 2020 17:41:59 GMT

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

Re: WildMatch() Complicated Logic

kaushiknsolanki — Thu, 16 Apr 2020 09:36:37 GMT

Hi,

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