Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all, I'm facing a strange problem importing data from a CSV.
If some rows contains " in a description column, after the import some rows are not correctly loaded in QlikView.
After removing only the character " replacing it with blank all works fine.
I'm import data from csv with the following statement
My_TAB:
LOAD
DATACAL as DateID,
ID_CDR as ID_CDR_MP,
ID_INTERVENTO AS ID_INTERVENTO_MP,
DENOMINAZIONE as DENOMINAZIONE_MP,
DESC_SUBS as PIANO_MP,
DATAINIZIO as DATAINIZIO_MP,
DATAFINE as DATAFINE_MP,
USERNAME as USERNAME_MP,
NOME as NOME_MP,
COGNOME as COGNOME_MP,
SOCIETA as SOCIETA_MP,
ESEGUITO as ESEGUITO_MP,
CONFORME as CONFORME_MP
FROM
MAN_PROG.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Can someone help me to identify the problem?
Best regards
Fabrizio
Try setting the Quoting to None. That way quotes won't be regarded as start/end tags of string values.
Try setting the Quoting to None. That way quotes won't be regarded as start/end tags of string values.