4 Replies Latest reply: Apr 2, 2013 9:03 AM by Marco Rizzo RSS

    Problem with data fields

    Marco Rizzo

      Hi.

       

      I'm reading 2 different excel files (w and v).

       

      I've got 2 fields data that I've renamed "data".

       

      I tried to use this script to be able to filter by data. The v-values start from 01-2013 while the w-values start from 02-2013.

       

      tab0:

       

      LOAD Data as data,

           Ora as orav,

           Giorno as giornov,

           [Telefono cliente] as [telefono cliente v],

           Secondi as secondiv,

           [Secondi Completo] as [Secondi Completov],

           Interno,

           [Numero Interno] as  [Numero Interno v],

           [Ragione sociale] as [Ragione Sociale v],

           Provincia as provinciav,

           Stato as statov,

           Flusso as flussov,

           Tipo as tipov,

           Categoria as categoriav,

           Macrocategoria as macrocategoriav

      FROM

      [C:\Users\Marco Rizzo\Desktop\LAVORO SU EVOLVE\excelreport.xls]

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

       

       

      LOAD [Partita Iva] as [Partita Iva w] ,

           [Ragione Sociale] as [Ragione Sociale w],

           Prodotto as Prodottow,

           Reparto as repartow,

           Interno,

           [Data inizio] as [Data inizio w] ,

           [Ora inizio] as [Ora inizio w],

           [Ultimo aggiornamento] as data,

           [Ora ultimo aggiornamento] as [Ora ultimo aggiornamento w],

           Modalità as modalitàw,

           Tempo as tempow,

           Priorità as prioritàw,

           Stato as statow,

           [Bloccato o Extra] as [Bloccato o Extra w]

      FROM

      [C:\Users\Marco Rizzo\Desktop\LAVORO SU EVOLVE\export webrecall.xls]

      (biff, embedded labels, table is Foglio0$);

       

       

      tab1:

       

      load Distinct data,

       

      year(data) as ANNO,

      Month(data) as MESE,

      Week(data) as SETTIMANA,

      WeekDay(data) as GIORNOSETT,

      Day(data) as GIORNOMESE,

      QuarterName(data) as TRIMESTRE

       

      resident tab0

      ;

       

       

      .............................

       

      It doesn't work. When I see the values available for the field data, there are only february and march.

       

      Any suggestion ?

       

      Thank a lot