RapidMiner

Write to Excel - automated file name basic on logic

SOLVED
Contributor I fbergstrand
Contributor I

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? 

2 REPLIES
RM Certified Expert
RM Certified Expert
Solution

Re: Write to Excel - automated file name basic on logic

Yes, just use the process start timestamp macro (which is always available by default) as part of the filename in your write Excel operator.

 

Brian T., Lindon Ventures - www.lindonventures.com
Analytics Consulting by Certified RapidMiner Analysts
Highlighted
RM Staff
RM Staff
Solution

Re: Write to Excel - automated file name basic on logic

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


How to load processes in XML from the forum into RapidMiner: Read this!