Reporting Service

[qlikuser-ak]

Hi,

Is there an option in Qlik Data load editor to read csv file with special character delimiters like  ║

For example this script is not working...

LOAD
id║email║last_name║first_name║create_date║update_date║is_deleted║phone║is_external║status_id
FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)

[Oleg_Troyansky · Accepted solution]

Have you tried this:

LOAD
               *

FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)

[qlikuser-ak]

Thank you, that did the trick!