Multiple value names for the one value

[#1]

Hi all, long time reader, first time poster!

I am building a simple Qlikview application at the moment, the source data is a single excel file and all the data resides in one table.

Unfortunately the data itself is quite messy. One problem I am encountering (I foresee many more!) at the moment is in the "Country" field. There has been no standardized data entry protocol, so for each country (e.g. Spain) I have multiple codes (e.g. ES, es, Spain).

I'm looking for a tidy solution to this problem. IF statements? Mapping tables?

Thanks in advance,

Michael

[#2]

If you had another table linked with country table, then you could use distinct... But this seems not the case. I'm trying to do something to help you, if I find the solution I'll post here.

[#3]

You could try something like this:

if([Country] = 'ES' or [Country] = 'e.g. ES' or [Country] = 'es' or [Country] = 'e.g Spain', 'Spain')

It's the easyest way that I found, on the other hand, it just work if the data is not so high.

[#4]

Hi Michael,

Better using mapping table.

Regards,

Srinivasan

[#5]

Many thanks guys!