Working with Filenames and Directories

Consider the following scenarios.

• Every day we export data from our database and would like to save it into a different file using the current date as a part of the file.
• We would like to load yesterday’s data from the folder which has date part in the name

We can use functions in filenames to do it as follows

GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of the date we can use LeftString(String,Count):String for example

LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8) will return only date part.

Now more complicated example for loading yesterday’s data;

LeftString(DecDateS(GETSYSTEMVARIABLE('SYSTEM_DATE'),'YYYYMMDDHHNNSS', 'DAY',1),8)

Another example:

C:\Data{GetSystemDate('YYYYMMDD')}.csv

For complete reference of available functions consult Supported Functions List

Only one {} pair is allowed.

• Advanced ETL Processor Professional and Enterprise Documentation
• Visual Importer ETL Professional and Enterprise Documentation