topic Re: Mapping Load with Commas in Data in QlikView

Mapping Load with Commas in Data

Anonymous — Wed, 16 Sep 2015 15:02:04 GMT

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

Re: Mapping Load with Commas in Data

Gysbert_Wassenaar — Wed, 16 Sep 2015 15:10:18 GMT

Put double quotes around the values.

Re: Mapping Load with Commas in Data

sunny_talwar — Wed, 16 Sep 2015 15:12:40 GMT

Or use a different delimiter like pipe (|)

LOAD * Inline [

blah blah

] (delimiter is |);

Re: Mapping Load with Commas in Data

petter — Wed, 16 Sep 2015 15:15:07 GMT

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 '|' );

Re: Mapping Load with Commas in Data

Anonymous — Wed, 16 Sep 2015 15:15:34 GMT

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

Re: Mapping Load with Commas in Data

Anonymous — Wed, 16 Sep 2015 15:15:55 GMT

Have you tried placing quotes around your values?

Re: Mapping Load with Commas in Data

Anonymous — Wed, 16 Sep 2015 15:22:05 GMT

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.