topic Re: INLINE LOAD: How to enter a value which has a comma? in QlikView

INLINE LOAD: How to enter a value which has a comma?

mwallman — Fri, 12 Oct 2018 13:04:29 GMT

Hi there,

I would like to create an INLINE LOAD table.

It will have Product Group, and Product Name fields

In my Product Name field I have some values which will be comma separated. How can I insert a value with a comma in it?

Such as

Product Name

Bread

Milk

Eggs, Meat

I don't want the comma to be confused with relating to values in the Product Group field.

sunny_talwar — Fri, 12 Oct 2018 13:09:00 GMT

Put the whole thing within Double Quotes

"Eggs, Meat"

nsetty — Fri, 12 Oct 2018 13:09:46 GMT

you can use '|' character as the alternative delimiter.

Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|CustomerID

Astrida|AA|1|10|1

Astrida|AA|7|18|1

Astrida|BB|4|9|1

Astrida|CC|6|2|1

Betacab|AA|5|4|2

Betacab|BB|2|5|2

Betacab|DD

Canutility|DD|3|8

Canutility|CC

] (delimiter is '|');

sunny_talwar — Fri, 12 Oct 2018 13:10:09 GMT

Something like this

Table:

LOAD * INLINE [

Product Name

Bread

Milk

"Eggs, Meat"

];