Dear community,
I have got a problem with the render tool.
Just for the background.
I am working on a workflow and there is only one input file with multiple sheets. The dynamic input tool will extract the data from each input sheet. At the end of the workflow, I am using the render tool to have all sheets just in one output file.
The name of the output file should rename dynamically (depends on client information) (e.g. ABC GmbH_2018_May).
Is there a way to read the file name from a column (named 'file name') using the render tool?
Many thanks!
Solved! Go to Solution.
Hey @r0deo4pple, if you select ‘Choose a specific output file’ in output mode, and then specify the location etc with a dummy name there. Then you can go down and select ‘Group data into separate reports’, choosing your ‘File Name’ field as the field to group on and under 'Modify file name by’, select ‘Replacing file name with group’.
@r0deo4pple
As suggested by @DataNath , we can specify the path or the file from input.
Below is a quick sample for it.
Hi @r0deo4pple, you can try this. But as per your screenshot you have not given any specific path so the report will be saved to the path where your workflow is saved by default.
I hope this helps!
Thanks!
Thank you for your responses so far!
But isn't the group by thing just for separate reports?
I want all the sheets (10 sheets) in one file...
And I don't want to type in the client information manually (e.g. if it is not the 'ABC GmbH' but the 'XYZ AG').
I worked with a dynamic input tool which extracts the client info. It would be really nice if the render tool can read the client info and rename it automatically.
I hope you understand what I mean.
Thank you!
@r0deo4pple the grouping field will create multiple outputs if you have more than one value in that field (i.e. if your data set contains many companies in the 'File Name' field). However, as you are dynamically pulling in just one from your input, there's nothing to split on and so, although the render tool is set up to create multiple outputs if applicable, it will only create one.
Do I have to add the file name column to every sheet that it will work ?
@r0deo4pple, while using the dynamic input tool you can bring in the file name which can be further used to group by in your render tool. Render tool will not be able to rename it unless you specify a rule or instead you can use the formula tool where you can specify your condition in if-else and then rename it accordingly if that is what you are trying to achieve?
Thanks!
Yes @r0deo4pple you can't leave it empty. You can just pull on a Multi-Row Formula - before your Render tool - to fill this 'File Name' all the way down through all of your rows. Configure it like so (example workbook also attached):
Before:
After:
Wow, it worked!
Thank you all for you responses.
That was my first question and it was solved just 2 hours later.
This community is crazy!