Dynamically chage the name of the input file.

kasturi

• April 02, 2012 00:00

• Answered

Follow

I am trying to read a file from data-in directory and process the data to insert into a table. The files comes from an external vendor and it has a yyyyDDMM at the end of the file. The first 6 letters of the file name will always remain the same, only the last part where it adds the date. How do I define that in clover so that I can read the file without manually updating the file name.
Thanks,
Kasturi

• 

  admin

  • April 03, 2012 06:21

  0

  Comment actions Permalink

  Hi Kasturi,
  
  you can use substitution by CTL expression or external parameter. See http://doc.cloveretl.com/documentation/ ... sions.html

Please sign in to leave a comment.