Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hey @Link86 - hoping this little explainer matches your scenario and can help. First of all, if you're grouping reports based on a certain field - [DOC NUM] in your case - then I'd imagine you're grouping the table like so:
Starting table:
Grouped within Table tool:
Because this field is being used for grouping, it remains outside of the Table itself as well, so we can reference it in a Formula expression to make your FileName field:
If it's still necessary (not sure on the full extent of your workflow), we can then just group on the newly-created [FileName] field in the Layout tool like so, which again keeps the layouts split out into the files they'll go into, like so:
Now, when using Reporting snippets, we Render the outputs, rather than using a standard Output Data tool. Here we can 'Choose a Specific Output File', navigate to the desired location and give it any name then hit Group Data Into Separate Reports, electing to group on filename and have this replace the filename (dummyfilename in our case). The result? 2 Excel files with the desired names like so:
Hope this helps! Demo workflow has been attached for you to look over and see what's happening.
