Write to Excel - automated file name basic on logic

fbergstrand

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? 

Telcontar120

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

 

IngoRM

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

Telcontar120

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

 

IngoRM

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