How to Handle Dimension where dimension values though same but are not proper ?

[shekhar_analyti]

Hi All ,

How to Handle Dimension where dimension values though same but are not proper ?

Shekar

[hector_munoz · Accepted solution]

Hi shektar,

In these cases the most common solution is to apply a text format function like Upper() (all characters in uppercase), Lower(all characters in lowercase) or Capitalize(first character in uppercase, the rest in lowercase). You have to take it into account when associating tables in a QlikView model.

Hope it serves!

Regards,
H

[swuehl]

I agree, that with your sample data, some simple text function like Capitalize() should do what you need: Create a consistent value per country name.

If there are other deviations in spelling than case, you can also consider a mapping approach:

Data Cleansing