topic Re: Passing parameter Dynamically to file naming convention in Talend Studio

Passing parameter Dynamically to file naming convention

Anonymous — Wed, 13 Apr 2016 16:19:26 GMT

HI,
files would be arriving on day to to day basis into UNIX directory, for example as mentioned below:
test.20160401,
test.20160402
if we are running job for 20160401 then talend job should pick file test.20160401 if if we are running job for 20160402 then talend job should pick file test.20160402.
so i want to pass time stamp as parameter to all files as extension for that job running date.
can you please help me how to achieve this task?
Thanks,
Bharath.K

Re: Passing parameter Dynamically to file naming convention

Anonymous — Thu, 14 Apr 2016 09:15:52 GMT

Hi,

so i want to pass time stamp as parameter to all files as extension for that job running date.

Could you please elaborate your case with an example with expected output values?
Here is a component tFileProperties which obtains information about the main properties of a defined file.
Best regards
Sabrina

Re: Passing parameter Dynamically to file naming convention

Anonymous — Thu, 14 Apr 2016 11:17:21 GMT

Hi,
Below is the example for my requirement:
Below is the source file name present in the job(extension-timestamp(YYYYMMDD) should be appended with file)
Sourc file Name: sales.YYYYMMDD
if we running job on April 14 2016 then our job looks file name as sales.20160414 in the directory
if we running job on April 20 2016 then our job looks file name as sales.20160420 in the directory
so whenever we running job how to pass dynamically timestamp as parameter to file name as extension?
Thanks,
Bharath.K

Re: Passing parameter Dynamically to file naming convention

talendtester — Thu, 14 Apr 2016 23:24:29 GMT

Are you running your job at the end of the work day?
String.valueOf( TalendDate.getDate("yyyyMMdd") );
If you need to wait for the day to be over and calculate yesterday's date to process the sales from yesterday it would look like this:
String.valueOf( TalendDate.addDate(TalendDate.getDate("yyyyMMdd"), "yyyyMMdd",-1,"DD") ) );

Re: Passing parameter Dynamically to file naming convention

Anonymous — Fri, 15 Apr 2016 11:01:13 GMT

no, we are running job every day, but i want to pass file name dynamically insted of hard code name in the jobs.
how we can implement this?

Re: Passing parameter Dynamically to file naming convention

Anonymous — Fri, 15 Apr 2016 11:09:26 GMT

Use a context variable or a globalMap variable for the filename. The context variable or globalMap variable will need to be set in a subjob prior to the one where the variable is being used to open the file.