Combine similar alternatives eg. Email,eMail, e-mail etc.

[AnnaQlik]

Hi, 

I want to combine similar alternatives into one alternative so the list won't be so long. You can see that several alternatives are the same but misspelled or with capital letters etc.

Can you please help me?

A

[m_woolf]

Create a mapping table that lists all the existing values and there corrected values. Then use Applymap to fix the data.

map_Data:
mapping
load * inline [
Value,Fixed
EMAIL,Email
Email,Email
email,Email
e-mail,Email
emial,Email

];

Data:
load
Applymap('map_Data',YourField) as YourField
from wherever;

[AnnaQlik]

Is YourField strKommunikationssaett and wherever  the database strKommunikationssaett comes from?

The mapping works fine but I have trouble with applying it so that it connects to the already existing field strKommunikationssaett.

Thank you!

[andrei_delta]

hi,

you can try Capitalize(Upper(Field)) as Field

Hope it helps,

Andrew

[AnnaQlik]

Thank you, but that won't help the misspellings.

I think mapping is the solution but I have not done it before and therefore need help to understand how I connect my inline mapping with the already existing data.

[m_woolf]

Applymap('map_Data',strKommunikationssaett ) as strKommunikationssaett 
from <the database strKommunikationssaett comes from>;

[AnnaQlik · Accepted solution]

I solved it by using load inline:

load * inline [
strKommunikationssaett,strKommunikationssaettnew
e-mail, Email
E-post, Email
e-post, Email
E-postDE, Email
EMAIL, Email
Email, Email
email, Email
emial, Email
epo, Email
Epost, Email
E-mejl, Email
E-mail, Email
];