Do not load when empty

[ift_isabelle]

Hi,

I have a dataset which has a total at the end.

I don't want to load it into my dataset.

How can I do that?

Date	Value	Remark
21/6/2016	5	This is the data i want to load
20/6/2016	4	This is the data i want to load
19/6/2016	3	This is the data i want to load
		This is an empty row which i want to delete
	12	This is the total row, which i don't want to load

I tried:

LOAD

     'Source1' As Source,

     [date],

     Value

FROM [lib://location.xlsx]

(ooxml, embedded labels)

Where [date] <> '';

Please help!

Thanks in advance,

Isabelle

[Colin-Albert]

Try     Where [date] > '';

[marcus_malinow · Accepted solution]

You could try

WHERE Len(Trim([date])) > 0