Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I consume a csv file filled with the values of the context variables that I load them with the tLoadContext component in the prejob and afterwards in the post job part I could not insert the value of the end date of the job execution in the same csv file, the error I got:
The process cannot access the file because this file is in use by another process!!
Hi
In the end of job, get the current date and write it to the CSV file, eg:
bababa
|onsubjobok
tFixedFlowInput--main--tfileOutputDelimited
on tFixedFlowInput: define the columns you want to write the file, maybe you need to rewrite all context variables, for the last execution date, you can get the current date with expression:
column: value
columnName:TalendDate.getCurrentDate()
let me know If you still have errors, and share a screenshot of your job.
Regards
Shong
So have you a recommanded method to set Last_Date_Out : contains last execution date than i get this date to filter my data from database?
Hi
In the end of job, get the current date and write it to the CSV file, eg:
bababa
|onsubjobok
tFixedFlowInput--main--tfileOutputDelimited
on tFixedFlowInput: define the columns you want to write the file, maybe you need to rewrite all context variables, for the last execution date, you can get the current date with expression:
column: value
columnName:TalendDate.getCurrentDate()
let me know If you still have errors, and share a screenshot of your job.
Regards
Shong