6 Replies Latest reply: Nov 9, 2012 10:29 AM by Erik Furlanis RSS

    When importing multiple csv in a folder, the header appears in the values

      Dear all,

       

      I have a number of csv files in a folder, named File1, File2 etcetc.

       

      I am loading from them using explicit labels, as I need to rename some fields

       

      problem is, if I use the following script

       

      FROM
      [Folder\File*.csv]
      (txt, codepage is 1252, explicit labels, delimiter is ',', msq);
      

       

      In the resulting fields the header is one value of the field.

       

      E.g, if it was

       

      LOAD
      @1 as Item
      

       

      In the resulting *.qvw, the Item fields is also going to contain an 'Item' value..

       

      any idea how to overcome this??

       

      Im clearly stating I have this problem when using explicit labels, because if I use embedded labels, the problem does not show up..

       

      Thank you!