QlikView Load Inline with another separator instead of comma

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 [
(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.