7 Replies Latest reply: Aug 14, 2012 9:49 AM by Erich Shiino RSS

    Simple CSV load (?)

    Erich Shiino

      Hi,

      I used wizard to load a simple csv file. The catch is a blank field name. QV generated the following script which fails..

      LOAD ,

           Field1,

           Field2

      FROM

      testLoad.csv

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

       

      The CSV content is just like this ( there is no name for the first field)

       

      ;Field1;Field2

      abc;1;2

      xyz;1;2

       

      I could load it like this, but I would need to rename the @X to the real field name and my real CSV has too many fields...

      LOAD @1,

           @2,

           @3

      FROM

      testLoad.csv

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

       

      So, how can I easily recognize this field renaming just this one?

      Regards,

      Erich