do not load empty rows - another question

cscherer — Thu, 27 Sep 2012 08:41:15 GMT

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

Re: do not load empty rows - another question

swuehl — Thu, 27 Sep 2012 08:49:37 GMT

Try

...

Where Len (trim(date)) >0;

cscherer — Thu, 27 Sep 2012 08:51:01 GMT

thanks!