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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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"