3 Replies Latest reply: Jun 26, 2017 8:57 AM by Sunny Talwar RSS

    problem with putting a condition about Table name

    Federica Posadino

      hi everybody, i have to load different tabs like these:

       

      i have different point of sales and i dont't have an ID inside each point of sales' files.

      i need a field that allow me to identified these point of sales for each table.

      Trieste:

      LOAD TipoDoc,

           NumDoc,

           Famiglia,

           DescFamiglia,

           CodicePLU,

           DescrizionePLU,

           Pezzi,

           Year(DtMov) as Anno,

           Month(DtMov) as Mese,

           Day(DtMov) as Giorno,

           NomeOperatore

      FROM

      [\\192.168.10.11\d$\CASSE\CasseCei_QW\68474\]TBVENDPC_*.CSV

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

       

      Udine:

      LOAD TipoDoc,

           NumDoc,

           Famiglia,

           DescFamiglia,

           CodicePLU,

           DescrizionePLU,

           Pezzi,

           Year(DtMov) as Anno,

           Month(DtMov) as Mese,

           Day(DtMov) as Giorno,

           NomeOperatore

      FROM

      [\\192.168.10.11\d$\CASSE\CasseCei_QW\68475\]TBVENDPC_*.CSV

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

       

      i hope i was clear..... thanks