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
Hi Kasturi,
you can use substitution by CTL expression or external parameter. See http://doc.cloveretl.com/documentation/ … sions.html