topic Re: Load non null rows in QlikView

Load non null rows

Thu, 04 Jun 2015 10:05:43 GMT

Hi All,

I have an excel file which contains many records. There might be some rows which are null. I wish to load only non null rows in qlikview.

Is it possible?

Thanks,

Asma

swuehl — Thu, 04 Jun 2015 10:11:23 GMT

Use a WHERE clause, for example like

LOAD

FieldA,

FieldB,

...

FROM ExcelFile.xls

(....)

WHERE len(trim(FieldA));

MayilVahanan — Thu, 04 Jun 2015 10:14:54 GMT

Try like this

Load * from datasource where len(trim(Field)) > 0;

U can replace Field with ur excel column name.

sgrice — Thu, 04 Jun 2015 10:18:14 GMT

get excel driver to do it for you

example

Load .....

From

someexcel.xls

(biff, embedded labels, table is I2$, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

))

The file wizard can build the statement. Enable Transform and then Conditional delete