Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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?