topic Re: import csv in QlikView

import csv

Mon, 26 Jan 2026 16:26:21 GMT

Hi,

i cant load a csv file in qlik view. After the load phase comes out an error that says: "the field TIMESTAMP doesn't exist".

Can you help me?

Re: import csv

Anonymous — Tue, 03 May 2016 15:35:58 GMT

Hi Marco,

It could be a misspelling error. Are you using the "Table Files" option in the Script Editor?...Maybe you can share an screenshot of your LOAD statement.

Regards,

-- Karla

Re: import csv

MarcoWedel — Tue, 03 May 2016 21:55:07 GMT

Hello Marco,

without seeing your csv file and the load statement it's rather difficult to tell what you did wrong ...

regards

Marco

Re: import csv

Wed, 04 May 2016 07:20:09 GMT

in the attached files there are the csv file and the screenshot of the error.

Thanks

Re: import csv

Wed, 04 May 2016 07:21:34 GMT

Hi Marco,

I attached the csv file and the error screenshot.

Re: import csv

Anonymous — Wed, 04 May 2016 07:39:58 GMT

Please share your CSV sample and the QVW so that issue can be tracked.

Regards

Nitin

Re: import csv

avinashelite — Wed, 04 May 2016 07:54:19 GMT

share your script statement and the CSV files ...so it will be useful for us to identify the issue .

As per your inputs, TIMESTAMP filed is missing in the CSV , check your csv files once

Re: import csv

Wed, 04 May 2016 07:57:29 GMT

The csv file is stuctured in this way: TIMESTAMP;VERSIONE;RETEACCESSO;ADNETWORK;URL_ADNETWORK;CLI_INDIVIDUATO;MSISDN_INDIVIDUATO;CLUSTER_INDIVIDUATO;SIMPLEDATE;HOUR;MSISDN;CLI;TUUID;PARTNER;SITE;ADVHUBTIME;ADNETWORKTIME;APIUNICATIME;APSTIME;USPTIME;CACHECOOKIEHIT;CACHEUSPHIT;NOME_CLUSTER;AREA;ETA';SESSO;TIPO_CLIENTE;LIVELLO_DI_CONSUMO;NAZIONE;PROVINCIA;TIPO_LINEA;IPADDRESSSERVER

2016-04-21 15:40:57.038+0200;1;Assente;ADFORM;Arricchita;CLI_Non_Individuato;MSISDN_Non_Individuato;NO;21/04/2016;15;Assente;Assente;Assente;Assente;TIM-MOBILE;410;245;147;0;0;false;false;;;;;;;;;;163.162.187.28

2016-04-21 15:42:06.747+0200;1;Assente;ADFORM;Arricchita;CLI_Non_Individuato;MSISDN_Non_Individuato;NO;21/04/2016;15;Assente;Assente;Assente;Assente;TIM-MOBILE;292;169;107;0;0;false;false;;;;;;;;;;163.162.187.28

The LOAD script is this:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';

SET LongMonthNames='gennaio;febbraio;marzo;aprile;maggio;giugno;luglio;agosto;settembre;ottobre;novembre;dicembre';

SET LongDayNames='lunedì;martedì;mercoledì;giovedì;venerdì;sabato;domenica';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

SET FirstMonthOfYear=1;

SET CollationLocale='it-IT';

LOAD TIMESTAMP,

VERSIONE,

RETEACCESSO,

ADNETWORK,

URL_ADNETWORK,

CLI_INDIVIDUATO,

MSISDN_INDIVIDUATO,

CLUSTER_INDIVIDUATO,

SIMPLEDATE,

HOUR,

MSISDN,

CLI,

TUUID,

PARTNER,

SITE,

ADVHUBTIME,

ADNETWORKTIME,

APIUNICATIME,

APSTIME,

USPTIME,

CACHECOOKIEHIT,

CACHEUSPHIT,

NOME_CLUSTER,

AREA,

ETA',

SESSO,

TIPO_CLIENTE,

LIVELLO_DI_CONSUMO,

NAZIONE,

PROVINCIA,

TIPO_LINEA,

IPADDRESSSERVER

FROM

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Re: import csv

Anonymous — Wed, 04 May 2016 08:37:40 GMT

may be this link is useful to you please check it and try it

Load a CSV file | Qlik Community

Re: import csv

Anonymous — Thu, 05 May 2016 01:56:38 GMT

Hi Marco,

It seems that your label ETA' is the problem due to the apostrophe, so to avoid this enclose this label in brackets and add an alias:

[ETA'] as ETA

This should solve the problem. Hope it helps.

-- Karla