Write to Excel - automated file name basic on logic
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
-
Telcontar120 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 -
IngoRM Employee-RapidMiner, 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