Dynamic Output file Path using Render tool

[wonka1234]

Hi,

Is there a way to do a dynamic path to output an excel file using the render tool?

I normally would create an extra column named path with the path + todays date and output tool to excel, but i need the data formatted.

any workarounds?

[ed_hayter]

I think this is fairly dynamic

I've originally put in a dummy place to save in the render - copy and pasted the path (everything before file name) then added my dynamic filename and included the date and then used the config in render to group by that field ( which will be the same for the whole table(s) and set it to replace whole path