Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I have a lot of csv files that I want to load into QlikView.
But I have a special "Delimiter" ---> "§"
How can I define such delimiters in the QV-Loading-Script?
(see also Printscreen)
Thanks in advance.
Patrick
Use the following script in the script editor:
TableName:
LOAD
*
FROM CSVFileName
(txt, utf8, embedded labels, delimiter is '§', msq);
Hope it helps!
Use the following script in the script editor:
TableName:
LOAD
*
FROM CSVFileName
(txt, utf8, embedded labels, delimiter is '§', msq);
Hope it helps!
Thank you - I will test it and get to you back again.
Patrick