9 Replies Latest reply: May 4, 2016 9:56 PM by Karla Rivas RSS

    import csv

    Marco Vicariucci

      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
          Karla Rivas

          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
            Marco Wedel

            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
              Nitin Gupta

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

               

              Regards

              Nitin

              • Re: import csv
                Avinash R

                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
                    Marco Vicariucci

                    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

                    [C:\Users\Marco\Desktop\ADVHUBC_2016042115400_001.csv]

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

                  • Re: import csv
                    V SUDHAKAR

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

                    Load a CSV file | Qlik Community

                    • Re: import csv
                      Karla Rivas

                      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