2 Replies Latest reply: Oct 22, 2012 9:03 AM by markmchenry RSS

    Categorizing List Box Data Advanced Fuzzy Search

      I pulled data from Salesforce.com and the table in QlikView contains leadID and SearchPhrase as fields.

      I am looking for a way to label SearchPhrase data as "branded" if it contains "phd" or "esxpress", and "nonbranded" if does not contain such words.  So then I can make a new list box called "Label" and have "branded" and "nonbranded" as the choices in the list box so i could easily see which leads were branded vs. non-branded.  I know I can do fuzzy searches for "phd" and "esxpress" on the SearchPhrase list box that I already have, but being able to create the "Label" list box would make analysis for end users much easier and better .  Anyone know how I can accomplish this?