Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_lin
Creator
Creator

Load an additional table for data normalization?

Hello Qlikers!

I have a list of companies for example: google, Google, GOOGLE, google.com and I want all of these to be just Google.

If there a way that I can load a table into Qlikview and normalized the name using that table as a reference.

Such a table in my mind would be:

Normalized Name     Name1     Name2     Name3     Name4

Google                    GOOGLE     google     google.com     Google

any thought?

Thanks!

Samuel

11 Replies
jsaradhi
Specialist
Specialist

you can't do case insensitive directly...but by using upper() or lower() for that matter and forcing all text values to one case for comparison purposes only, you can get around this.

as far as the wild mapping is concerned, try index() function.

=index('amazonapplegooglesamsung', 'google')


MarcoWedel

Hi,

maybe helpful:

if condition

regards

Marco