How to customize output file name in Render without including filename field in output?

[ChrisK1]

I've seen a few articles on this topic, but none answer the specific problem I have. I can successfully dynamically update the filename including a formula with the specific naming convention using a series formulas. I can make that happen fine and the filename updates beautifully, thanks to the tips of this community!

Problem: The field I am using to Group Data Into Separate Reports, how can I remove this from the output so that it's not visible? The purpose of using render is so that I can format the output to make it client ready, and automatically, without the need to manually delete the field in the output. Any ideas for how to configure this?

[AndrewBanh · Accepted solution]

Hi @ChrisK1 

Without looking at your Reporting Tool configurations, I can only guess what may be the issue.

Looking at your Basic Table tool, I assume you have your filepath in the Group By panel, but have you deselected it from your Per Column Configuration so you only have the tables you want to appear on your report?

If you still Group By your filepath, you can still use that field in your Render Tool.

If that doesn't work, please take a screenshot of your tool configurations :)

- Andrew

[ChrisK1]

Thanks! I was completely overlooking the basic table configuration. I removed Filename field from the table list and I'm good now!

[Teresa2]

Hey, I got a similar problem. I don't want the file name to be in the output. I deselect the file name in the table 'per Column Configuration'. But the file name is still in the output. Any ideas? 

Thank you for help!! 🙂