Dynamic File names

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

Note:

Only one pair of {} is allowed

For example:

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

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

Note:

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

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

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;

Building a complex file name

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

Confused? Ask question on our ETL forum

  • aetl/dynamic_file_names.txt
  • Last modified: 12/07/2015 18:37
  • by admin