Write to Excel - automated file name basic on logic
![fbergstrand](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
I've search the forum but not found my specific question.
I'm writing one file to Excel daily per processer and wonder if there is a way to automatically name the Excel file name with today's date. As i use the same process once a day and need to save the old file i do not want to overwrite previous runs.
The files are all saved in the same folder and i would want to specifiy a condition that the files are named E YYYY-MM-DD, is that possible?
Best Answers
-
Options
Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635
Unicorn
Yes, just use the process start timestamp macro (which is always available by default) as part of the filename in your write Excel operator.
1 -
Options
IngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751
RM Founder
Yip, Brian is right. The old default macro %{t} might also still work...
The following two links are going to be useful if you macros for the first time:
https://docs.rapidminer.com/studio/getting-started/macros.html
http://community.rapidminer.com/t5/RapidMiner-Studio-Knowledge-Base/How-to-Use-Macros/ta-p/32966
Hope this helps,
Ingo
1