Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Have you tried this:
LOAD
*
FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)
Have you tried this:
LOAD
*
FROM [lib://Data/UserAction/]
(txt, utf8, embedded labels, delimiter is '║', msq)
Thank you, that did the trick!