Misplaced Comma in a field variable

[#1]

I am relatively new to Qlik and my problem is around and issue with a field variable which I believe Qlik is treating as a No-Map issue from a Mapping Table.

I have a field called CoverType, within this filed there is a value Comprehensive - Mobility Scooter, Wheelchair (please note the comma after scooter is part of the value and not the map name. When I include this entry in a mapping table (eg Comprehensive - Mobility Scooter, Wheelchair, Comp_MSW) it returns an No-Map value. I understand why it is occurring (the comma after Scooter).

I have reviewed a number of other potential solutions online however, unfortunately I believe that it is one of these cases where the filed value with its unfortunately placed comma is not lending it to any solution that I have come across. I do have a solution to overcome this however it will create a significant amount of work  and was hoping the Qlik guru's out there may have some solution to this dilemma.

Cheers in advance Wishman

[Peter_Cammaert]

A LOAD INLINE statement allows the optional specification of another delimiter character. You can set it to some character that you are sure it doesn't occur in your input data. Like for example, a tab character in

Mapping LOAD * INLINE [
RAAScheme_CoverType    Group
Comprehensive - Car    Comp_Car
Comprehensive - Lifetime Vehicle Replacement    Comp_Car
Comprehensive - Caravan    Comp_Cvn

Comprehensive - Mobility Scooter, Wheelchair    Something
] (delimiter is '\t');

That way, the scripting engine will not treat commas as separators.

Note: everything - except $-sign substitutions - between the square brackets is treated as text. No expressions are evaluated.

[#3]

Hey Pete

If I could give you a hug I would, worked a treat thanks a million

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

[#5]

Where is this so called correct answer button located, I even asked a couple of colleagues to see if they could see one which you make reference to and they both came up blank!!!!

[Anil_Babu_Samineni]

Qlik Community Tip: Marking Replies as Correct or Helpful

[#7]

Did that previously once I had the answer and said all was ok so not sure what's going on

[Anil_Babu_Samineni]

Let it be