import csv

[#1]

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?

[Anonymous]

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

[MarcoWedel]

Hello Marco,

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

regards

Marco

[#4]

Hi

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

Thanks

[#5]

Hi Marco,

I attached the csv file and the error screenshot.

[Anonymous]

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

Regards

Nitin

[avinashelite]

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

[#8]

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);

[Anonymous]

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

Load a CSV file | Qlik Community

[Anonymous]

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