Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
...
Where Len (trim(date)) >0;
thanks!