Matching Column Data based on a set number of characters
I have a situation where I am trying to match two columns of names. The First column is the correct name in my system. The second column is from our contracting system and contains different punctuation and different endings (such as "inc" or "corp"). I would like to match them up based on the first four characters of the names. I know that will give us multiple options but it will be close enough to fit my purpose.
Does anyone have any idea how to get Qlikview to make this match?