QlikView Load Inline with another separator instead of comma

July 18, 2017
No Comments

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 

load inline

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:

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

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.