Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaQlik
Partner - Contributor II
Partner - Contributor II

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

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?

AA

Labels (1)
1 Solution

Accepted Solutions
AnnaQlik
Partner - Contributor II
Partner - Contributor II
Author

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
];

View solution in original post

6 Replies
m_woolf
Master II
Master II

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
Partner - Contributor II
Partner - Contributor II
Author

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
Partner - Creator III
Partner - Creator III

hi,

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

Hope it helps,

Andrew

AnnaQlik
Partner - Contributor II
Partner - Contributor II
Author

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
Master II
Master II

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

 

AnnaQlik
Partner - Contributor II
Partner - Contributor II
Author

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
];