HomeForum
Welcome, Guest

Dynamic Filename set through a a variable
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Dynamic Filename set through a a variable

Dynamic Filename set through a a variable 10 months, 2 weeks ago #3141

  • oxalagu
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
I need to create dynamic filenames based on the input parameter for a selection set in a variable.
How can I create a filename for output (or as a part of file operation, like copy, rename) where a part of the filename uses the content of a workflow variable?

There is a lot about extracting a filename from inpout, but I want to define the filename dynamically, e.g. JANUARY.csv, FEBRUARY.csv ... depending on selection.

Re: Dynamic Filename set through a avaiable 10 months, 2 weeks ago #3142

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
In script

begin
SetVariable('<file_name>','august');
result:=true;
end;

than in file name

c:\temp\<file_name>.txt

Mike
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"Using Visual Importer ETL was a lot easier than we expected it to be, and had a lot more functionality than our other software."

Daniel Boel,
Information Technology Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top