I'm trying to map a table of clients and codes corresponding to product elections with a table of products and the code that implies that the product in question has been purchased. Hopefully the tables below will clear up what I mean:
|Mapping Code||Product ID||Product Name|
where the Product mapping code follows the standard convention of '?' representing any single character and '*' any single or combination of characters.
I was able to employ the "Mapping With WIldcards" recipe from Rob Wunderlich's site (Qlikview Cookbook | Recipes for Qlikview Success) within a while loop (see attached QVW), followed by a Left Join to achieve what I guess is effectively a "Wild Left Join":
"Joining" the above tables in this manner yielded precisely what I sought, when the appropriate fields were places in a table box:
|Client||Product ID||Product Name|
However, when I try to use the same method on non-dummy data (say, a 545-row list of products and a 25000-row list of clients), I don't get an error during the reload, but when I create the table box, I see that many clients are not properly mapped to their respective products. For example, client 'A' in the above tables might only be mapped to products 1 and 4, or even just product 1.
Would anyone be able to offer any thoughts as to why this might be happening?
Thank you in advance for your help.