Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
lubicz99
Valued Contributor

Mapping Load with Commas in Data

Greetings Forum,

Looking for a quick answer on this.  I created a mapping table with 4 values.   3 of my 4 values have a comma mid value.   My data load is going to take a long time and I have not had to deal with this before.  How do  I insure the whole value is considered in the applymap statement.   Do I put single quotes around the values, double quotes or parenthesis or something else?

See my PNG file for view of my script

I looked through the forum and did not find the answer

Thanks for any responses


Tags (1)
1 Solution

Accepted Solutions

Re: Mapping Load with Commas in Data

Put double quotes around the values.


talk is cheap, supply exceeds demand
6 Replies

Re: Mapping Load with Commas in Data

Put double quotes around the values.


talk is cheap, supply exceeds demand

Re: Mapping Load with Commas in Data

Or use a different delimiter like pipe (|)

LOAD * Inline [

blah blah

] (delimiter is |);

MVP
MVP

Re: Mapping Load with Commas in Data

You can use another delimiter instead of comma perhaps - like vertical bar ?

Hypoclycemia:

MAPPING LOAD * INLINE [

HIC3_DESC | Drugs

INSULINS | Yes

ANTIHYPERGLYCEMIC, INSULIN-RELEASE STIMULANT TYPE | YES

ANTIHYPERGLYCEMIC, INSULIN-REL STIM.& BIGUANIDE CMB  | YES

ANTIHYPERGLYCEMIC, THIAZOLIDINEDIONE AND SULFONYLUREA | YES

] (delimiter is '|' );

lubicz99
Valued Contributor

Re: Mapping Load with Commas in Data

Both seem like excellent options.  Thanks for the quick response.

napac1458
Contributor II

Re: Mapping Load with Commas in Data

Have you tried placing quotes around your values?

lubicz99
Valued Contributor

Re: Mapping Load with Commas in Data

Love that option.  We often have descriptive data where commas slip in, so we might be using vertical bars as delimiters as SOP in the future.

I solved my immediate problem using the double quotes and my data loads and works as expected.   Thanks again for all of the responses and I also plan to use alternate delimiters in the future too.

I started out only needing to solve my problem, but ended up gaining some extra wisdom in the process.

Community Browser