Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Building a Complex File Name

Building a Complex File Name 2 years 4 months ago #16606

Hi,

I have reviewed all the demos - I am building a dynamic file name split. The split works fine.

I am trying to build a better filename, first part is the sort variable [F001] then I want to append the original file name.

I tried the following in the writer:
\file_{GetVariable('<file_name>');GetSystemVariable('SOURCE_FILE_NAME')}.txt

and here is my sorter:

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

How can I achieve:
F001_SOURCE_FILE_NAME

Thank you!

Please Log in or Create an account to join the conversation.

Building a Complex File Name 2 years 4 months ago #16608

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7618
  • Karma: 33
  • Thank you received: 419
Can you try:

\file_{GetVariable('<file_name>')+GetSystemVariable('SOURCE_FILE_NAME')}.txt
Mike

Please Log in or Create an account to join the conversation.

Building a Complex File Name 2 years 4 months ago #16609

Perfect!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 233 guests and no members online