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

TOPIC: passing data variable to outbound file name

passing data variable to outbound file name 5 months 1 week ago #18909

Hey everyone,
long time since I have had a question for you
lets says I have a column in a table labeled custid
this table has data with many custids in it
I want to run a query and pull off a specific custid and get that custid into the outbound file name.
similar to having system data and time
so if the custid being processed in the data is "CHRYLER"
if need the file name to be data_CHRYSLER_yyyymmddhhmmss.csv
I know how to get the yyyymmddhhmmss

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

passing data variable to outbound file name 5 months 1 week ago #18912

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7544
  • Karma: 33
  • Thank you received: 412
Hello.

Default repository has an example called "Dynamic file names 2"
IT creates a separate file per year using a variable.

Mike
Attachments:

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

  • Page:
  • 1

We have 262 guests and no members online