Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try Where [date] > '';
You could try
WHERE Len(Trim([date])) > 0