Load data conditionally

[dukane24]

Hello,

I have an app where one of my data sources is an Excel spreadsheet.  The spreadsheet has data going back 11 years and I don't need all of it.  Provided that there is a date field to go by in the data, is it possible to change my load script so that it will only load data for, for example, 2013 and 2014?

Thanks in advance!

[maxgro]

with a date field

where match(year(datefield), 2013, 2014)    

[#3]

Hi,

You can use where clause with greater-than-sign.

For example:

LOAD *

FROM abc.qvd

where Date > 31/12/2012;

This is more flexible solution because, you can fix date. Also you can use in case when the date field is numeric.

But if you can use the Massiomo Grossi's solution, choose his solution because it works fastest.

You can see also "Enable Transformation Step" options from "Table Files Load".