Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')