Good morning everyone,
I am currently using the render tool at the end of a workflow in which the file path is updated every day with a formula. In the render tool at the end of the formula I am then flagging "group data into separate reports" --> field to group on: path --> modify filename by replacing entire path with group. In this way, however, since the path is added to every single line in the excel, the final data is somewhat "dirty". Is there a way to hide the path column in a similar way as unflagging the option "keep field in output" for the output tool?
Thank you in advance
Solved! Go to Solution.
Hey @GiovanniB
I presume your using a table tool before render?
If so, you can untick the column in the column configuration (even though you have ticked it to group on)
You presumed correctly, thanks!