Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
cscherer
New Contributor

do not load empty rows - another question

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: do not load empty rows - another question

Try

...

Where Len (trim(date)) >0;

2 Replies
MVP
MVP

Re: do not load empty rows - another question

Try

...

Where Len (trim(date)) >0;

cscherer
New Contributor

Re: do not load empty rows - another question

thanks!

Community Browser