2 Replies Latest reply: Sep 27, 2012 4:51 AM by Clemens-A. Scherer RSS

    do not load empty rows - another question

    Clemens-A. Scherer

      Hello,

       

      I´ve got another question regarding the load of empty rows.

       

      I´ve got this script:

       

      Directory;

      LOAD date,

           amount,

           site

      FROM

      test_emptyrows.csv

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

      Where Len ((date ) >0);

       

      In my data source there are rows without date but with values in the other fields. This rows I do not want to load. What do I have to change?

       

      Thanks,

      cscherer