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

TOPIC: tarrget file name

tarrget file name 2 weeks 6 days ago #19854

When i import fles, i store the input file name in a data column called srcfile
i now need to use that data column when i export the file,but need to add something like step02 onto the srcfile
I need this especially on the data export object
can this be done, show me the way

thanks

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

tarrget file name 2 weeks 6 days ago #19855

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7792
  • Karma: 33
  • Thank you received: 463
You can use variables for that.

Use to "Set Variable Action" to assign filed value to a variable ( call it <FileName> for example)
www.etl-tools.com/wiki/aetle/packages/set_variable_action .

Than use <FileName> to export the file
Mike

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

tarrget file name 2 weeks 6 days ago #19856

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7792
  • Karma: 33
  • Thank you received: 463
If it is not clear we can create a more detailed example for you
Mike

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

tarrget file name 2 weeks 6 days ago #19858

Here is a more detailed example







Peter Jonson
Support Analist
Attachments:

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

  • Page:
  • 1

We have 176 guests and no members online