I'm hoping someone can point me in the right direction. I have a list of names that I need to compare to another list of names. Within the script, I would like to grab one name, do some cleanup on it, and see if that name exists in my other table. Would I need to do this using a select function? Or is there another function that can be used to search for a string value within a table?
Also, does QlikView support any kind of fuzzy matching on a string?
dragonauta wrote:I'd give applymap() a try for that.
Good idea, or what I usually use, mapsubstring(capitalize()). It's a good way to resolve minor name differences if you have few enough names that you can look for and resolve problems manually (and I'm not sure how much I'd trust a computer to do it anyway).
Here's a simple example from one of my applications.
[Text Map]: MAPPING LOAD * INLINE [ Replace This, With This Anthony Proznick, Tony Proznick Daniel Sutton, Dan Sutton Douglas Johnson, Doug Johnson Gerald Sifferman, Gerry Sifferman Elizabeth Bunosky, Liz Bunosky Human Resources, HR Kameron Davis, Kami Davis Kijeong Yi, Kory Yi Marilyn Lindberg, Beth Lindberg Mccarthy, McCarthy Mckee, McKee Mcmahon, McMahon New Request Submitted, New Paul Obermire, Michael Obermire Randall Thompson, Randy Thompson Rebecca Alvarez, Becky Alvarez Robert Silva, Bob Silva Salvatore Sbranti, Sal Sbranti Thomas Blasingame, Tom Blasingame WEB, Web Willard Bunyan, Bill Bunyan William Waters, Bill Waters William Swenson, Bill Swenson ];
