Load non null rows

[#1]

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]

Use a WHERE clause, for example like

LOAD

     FieldA,

     FieldB,

...

FROM ExcelFile.xls

(....)

WHERE len(trim(FieldA));

[MayilVahanan]

Hi

Try like this

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

U can replace Field with ur excel column name.

[sgrice]

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