https://community.qlik.com/t5/QlikView/Approximate-match-for-string-in-the-load-script/m-p/1707382#M455611 <P>Hi</P><P>In the load script, I have a nested applymap running. I have multiple tables, where the output i have to return is the same, but the mapping key will change. Hence nested applymap.&nbsp;</P><P>&nbsp;</P><P>However, now I need to do approximate matches. For example, map ID in my table will be "abc xyz pvt ltd" and other mapping tables might have it as "ABC XYZ MGT" or "ABC"&nbsp; something like that. Basically I need wildcards where I can map using ABC* or something. Can you please help me on how this can be done in Qlikview?&nbsp;</P><P>Thanks</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22245">@swuehl</a>&nbsp;&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18624">@Gysbert_Wassenaar</a>&nbsp;&nbsp;</P> Sat, 16 Nov 2024 18:33:20 GMT Anji0610 2024-11-16T18:33:20Z https://community.qlik.com/t5/QlikView/Approximate-match-for-string-in-the-load-script/m-p/1707382#M455611 <P>Hi</P><P>In the load script, I have a nested applymap running. I have multiple tables, where the output i have to return is the same, but the mapping key will change. Hence nested applymap.&nbsp;</P><P>&nbsp;</P><P>However, now I need to do approximate matches. For example, map ID in my table will be "abc xyz pvt ltd" and other mapping tables might have it as "ABC XYZ MGT" or "ABC"&nbsp; something like that. Basically I need wildcards where I can map using ABC* or something. Can you please help me on how this can be done in Qlikview?&nbsp;</P><P>Thanks</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22245">@swuehl</a>&nbsp;&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18624">@Gysbert_Wassenaar</a>&nbsp;&nbsp;</P> Sat, 16 Nov 2024 18:33:20 GMT https://community.qlik.com/t5/QlikView/Approximate-match-for-string-in-the-load-script/m-p/1707382#M455611 Anji0610 2024-11-16T18:33:20Z https://community.qlik.com/t5/QlikView/Approximate-match-for-string-in-the-load-script/m-p/1707474#M455612 <P>Probably have a look at this wonderful post by&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6148">@rwunderlich</a>&nbsp;</P><P>&nbsp;</P><P><A href="https://qlikviewcookbook.com/recipes/download-tag/mapping/#squelch-taas-accordion-shortcode-content-2" target="_self">Mapping with WildCards</A></P> Tue, 02 Jun 2020 13:37:37 GMT https://community.qlik.com/t5/QlikView/Approximate-match-for-string-in-the-load-script/m-p/1707474#M455612 vamsee 2020-06-02T13:37:37Z