3 Replies Latest reply: Jul 11, 2013 5:56 AM by Fabrizio Crespi RSS

    Problem with csv loading

      Hi to all, I'm facing a strange problem, I'm trying to upload a csv file with three column, all data are imported but there are several invalid column

       

      I've attached the file looking at the table generated by the import there are several rows with null as ID_RICH (ID_RICH value is displayed in column DateID)

       

      Here you are the script :

       

      RICHIESTE_MANORD:

      LOAD

      @1 as ID_RICH,

      @2 as DateId,

      @3 as COD_STATO

      FROM

      RICH_MANORD5.csv

      (txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);

       

       

      Can someone help me to identify the problem.

      Thank you in advance for your help.

       

      Fabrizio