Load an additional table for data normalization?

[samuel_lin]

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

[Anonymous]

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