Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Appending date to tFileoutputExcel every time job runs

Hello everyone
I am writing a job that runs weekly. The output is an excel file. How do I append a date when job is run to the output excel. E.g. if the job runs today (1.20.2015) and Excel name is TEST_JOB, I would like the Excel to be called TEST_JOB_01.20.2015.xlsx. When the job runs a week from now the excel name should be TEST_JOB_01.27.2015.xlsx. I am not very concerned about the formatting of the date as much as how to get it there 0683p000009MACn.png
Any advice is greatly appreciated.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

The output path of the file must be assembled like this:

"/var/data/" + jobName + "_" + TalendDate.getDate("MM.dd.yyyy") + ".xlsx"