WildMatch() Complicated Logic

[RD_Nol]

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:

Need your help guys.

Thanks in Advance.

Regards,

Nol

[kaushiknsolanki · Accepted solution]

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.

[RD_Nol]

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]

Great. Hope you learned something new. 🙂

[RD_Nol]

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]

Hi,

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