Load only if condition is met

[#1]

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.

[sunny_talwar · Accepted solution]

Something like this:

FOR EACH File in Filelist()

     IF Condition then

          Load *

          From ...

          Where

     ELSE

          ...

     ENDIF;

NEXT File;