Did you know that you can insert cells containing comma directly from the load * inline command?
Appearance seems trivial at first glance, but because the comma is the standard delimiter of the command [qlikview]load inline[/qlikview] it becomes even painful if in the defined columns we need formulas or lists that inherently contain commas for a purpose other than to delineate the loaded columns.
Here’s an example: we have a table with three columns: Instrument, Player and Project.
But, in the Project column, we need to bring all the projects, as a comma separated list and in the Player column, the list of all the interpreters is also separated with comma.
The solution is here:
[qlikview]Load * inline [Instrument|Player|Project
Guitar|Neil,Mike|Music,Video
Guitar|Neil|Music,OST
Synth|Neil,Jen|Music,Video,OST
Synth|Jo|Music
Guitar|Neil,Mike|Music,OST
]
(delimiter is ‘|’);
[/qlikview]
And the result is:
PS: This also allows you to copy / paste data from a pipe (|) delimited CSV without replacing the semicolons manually in the inline command.