topic Load data conditionally in QlikView

Load data conditionally

dukane24 — Tue, 08 Jul 2014 20:40:01 GMT

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!

Re: Load data conditionally

maxgro — Tue, 08 Jul 2014 20:50:31 GMT

with a date field

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

Re: Load data conditionally

Tue, 08 Jul 2014 21:49:22 GMT

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".