- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
you can try Capitalize(Upper(Field)) as Field
Hope it helps,
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Applymap('map_Data',strKommunikationssaett ) as strKommunikationssaett
from <the database strKommunikationssaett comes from>;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];