Load only if condition is met

Tue, 10 May 2016 12:24:20 GMT

Hi Guys,

I have a folder location where everyday a new csv-file is inserted. Now I have written an initial load into a QVD for the first month but this is not incremental. From now on I don't want to load all the files but only the files with an date modified that is equal to today, so basicly only the new and updated files.

I want to write something like:

FOR EACH File in Filelist()

IF(Condition,

Load *

From ...

Where

, Next File)

Hope you can help me out.

Re: Load only if condition is met

sunny_talwar — Tue, 10 May 2016 17:24:18 GMT

Something like this:

FOR EACH File in Filelist()

IF Condition then

Load *

From ...

Where

ELSE

...

ENDIF;

NEXT File;

topic Load only if condition is met in QlikView

Load only if condition is met

Re: Load only if condition is met