Dynamic File names

Dynamic file names is a quite common task and there are multiple ways of doing it

Calculations

It is possible to use calculated filenames by placing calculation inside {}

Only one pair of {} is allowed

Example

This will use today date to generate the filename

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

and that one will use yesterdays date

C:\Data\{DecDateS(GetSystemDate('YYYYMMDD'),'YYYYMMDD','DAY',1)}.txt

Variables

<CommonDocumentsDir>\DBSL\{GetSystemVariable('SOURCE_FILE_NAME')}.txt

<CommonDocumentsDir> is a variable and will be replaced with an actual value before execution

C:\Data\{GetVariable('<file_name>')}.txt

More complex example

This calculation will create a new file every time [F001] is changed

begin
if GetVariable('<file_name>')<>[F001] then // record changed
 begin
  SetVariable('<file_name>',[F001]);
  SourceChanged; // creating new file
 end;
 Result:='test';
end;

Default repository has a number of useful examples

Building a complex file name

Advanced ETL Processor

Learn BUY - $690

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Calculations Dynamic File names

Last updated: September 9, 2022

Lookups

Email Templates

On this page

Docs