How to normalize data in Qlik Sense with Excel File

[Nolgath]

I have a problem.

I have some fields in Qlik Sense like "make" "model" "gearbox" "fueltype" etc. Where the information is there but for example for Citroen i have values like CItroen,CITROEN, citroen, cítroén. And the same for other fields. So when i do a filter i need to select all of them just to get "Citroen" this can result in errors in data reading and getting wrong data and missing data. 

I have 2 files that were premade by a senior Data Scientist but it is very hard to get in touch with him so i am asking here for some enlightment.. 

How can I do so that i normalize the data ? I have attached the excel files that I have.. 

[ogster1974 · Accepted solution]

A few suggestions for you.

Use some string functions to tidy up your list.

Replace(Model, 'í', 'i') to replace chars

Upper(Model) to capitalise all values

Trim(Model) to remove extra spaces

Another way might be to keep a list of invalid and valid value and use applymap() to replace these out.