This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
I solved it by using load inline:
load * inline [strKommunikationssaett,strKommunikationssaettnewe-mail, EmailE-post, Emaile-post, EmailE-postDE, EmailEMAIL, EmailEmail, Emailemail, Emailemial, Emailepo, EmailEpost, EmailE-mejl, EmailE-mail, Email];
View solution in original post
Create a mapping table that lists all the existing values and there corrected values. Then use Applymap to fix the data.
map_Data:mappingload * inline [Value,FixedEMAIL,EmailEmail,Emailemail,Emaile-mail,Emailemial,Email
Data:loadApplymap('map_Data',YourField) as YourFieldfrom wherever;
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.
you can try Capitalize(Upper(Field)) as Field
Hope it helps,
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.
Applymap('map_Data',strKommunikationssaett ) as strKommunikationssaett from <the database strKommunikationssaett comes from>;