topic Re: Mapping with wildcards in QlikView https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411457#M1166448 <HTML><HEAD></HEAD><BODY><P>The wildmatch table has about 100 records, and indeed that does not fit that is why I am looking for another solution.</P></BODY></HTML> Sun, 14 Oct 2012 07:10:28 GMT 2012-10-14T07:10:28Z Mapping with wildcards https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411454#M1166445 <HTML><HEAD></HEAD><BODY><P>I have tried Mapping with wildcards from the QV Cookbook <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> (</SPAN><A class="jive-link-external-small" href="http://robwunderlich.com/downloads/" style="background-color: #ffffff; color: #007fc0; font-family: Arial;">http://robwunderlich.com/downloads/</A><SPAN style="background-color: #ffffff; color: #737373; font-family: Arial;">)&nbsp; example "Mapping with a table using wildcards" .</SPAN></P><P></P><P><SPAN style="background-color: #ffffff; color: #737373; font-family: Arial;">This works perfect for a few lines, but If I want to use it for more than approx 10 statements than it's not working anymore. </SPAN></P><P></P><P><SPAN style="background-color: #ffffff; color: #737373; font-family: Arial;">Does anyone have another solution?<BR /></SPAN></P><P></P><P></P><P>Thanks!</P></BODY></HTML> Sat, 13 Oct 2012 11:41:16 GMT https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411454#M1166445 2012-10-13T11:41:16Z Re: Mapping with wildcards https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411455#M1166446 <HTML><HEAD></HEAD><BODY><P>It's for using in a qwv for bankstatements. The used discription is always mixed in length, place of the needed part and use of numbers and letters. Eg</P><P></P><P>Descriptions:</P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1 NEXT FIRM 55663</P><P>PLACE 69.12.63</P><P></P><P>I want to have then:</P><P>Descriptions:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label3</P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SUPER*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BREAD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyA</P><P>1 NEXT FIRM 55663&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *FIRM*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MEAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyB</P><P>PLACE 69.12.63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *69.12*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyC</P><P></P><P>Etc etc for many+ descriptions.</P></BODY></HTML> Sat, 13 Oct 2012 15:39:45 GMT https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411455#M1166446 2012-10-13T15:39:45Z Re: Mapping with wildcards https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411456#M1166447 <HTML><HEAD></HEAD><BODY><P>How many records does your wildmatch mapping table have? As far as I can see Rob's approach creates two string variables. If you have a large wildmatch table, maybe the keys and labels don't fit in the strings anymore, ie the length becomes bigger than a string variable can contain. </P></BODY></HTML> Sat, 13 Oct 2012 16:52:52 GMT https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411456#M1166447 Gysbert_Wassenaar 2012-10-13T16:52:52Z Re: Mapping with wildcards https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411457#M1166448 <HTML><HEAD></HEAD><BODY><P>The wildmatch table has about 100 records, and indeed that does not fit that is why I am looking for another solution.</P></BODY></HTML> Sun, 14 Oct 2012 07:10:28 GMT https://community.qlik.com/t5/QlikView/Mapping-with-wildcards/m-p/411457#M1166448 2012-10-14T07:10:28Z