This content has been marked as final. Show 2 replies
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?
|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|
'Source1' As Source,
(ooxml, embedded labels)
Where [date] <> '';
Thanks in advance,