PDF/Excel Output to template with multiple sheets & filenames based on grouping

[Inactive User]

Hello Community,

Hoping to get some additional help and building on another thread with similar title.

Background:

I have 2 large datasets in separate sheets and two additional formatted sheets as the template. The datasets have common groupings.

I've attached sample flow and sample output template that is a representation of my datasets and output requirements.

The workflow should populate the same template for multiple groupings and iterate through populating 2 data streams on 2 different sheets in the same file.

Expected Output:

- Formatted template sheets included in each grouping files.

- Each file contains two sheets with their respective datasets.

- If the grouping does not exist in one or the other dataset, only the header is shown for that sheet

- Output each file both PDF and excel format.

[AmalinaH]

I made some adjustments to the configuration of the file output to keep the formatting of the fields. Namely to map by field name, skip field names when appending to existing sheet and defining the range.

As for saving as a pdf - I used the Basic Table tool and brought the two Data Sets together under a union. Using a render tool, we can group data into separate reports so that you have a separate PDF for Grouping A, B, C and so on.

Hope this is closer to what you were after?

[Inactive User]

Thanks for sharing the solution, @Amalina. The solution works only for the excel output. Looking for the PDF replica output in multiple pages as well. Maybe there's way to use the dynamic input to convert all the excel output files into PDF?

[ddiesel]

Hi @Inactive User!

Did @AmalinaH's solution work for you? If so, please mark as accepted.

Thank you!

[Inactive User]

Waiting on the PDF solution...

[AmalinaH]

Hi @Inactive User, I have included PDF output in this solution. It generates a separate PDF for each group, and each PDF has 2 pages (1 for each sheet).

PDF output can only be generated with the render tool and it will not look perfectly like the result of an excel file saved as a PDF using the excel program.

With some changes to the formatting using the table configuration you can get the formatting to something similar.

[Inactive User]

Hi Amalina, can you kindly screenshot the settings where to select for separate pages for the PDF output. It still showing within the same page.

[AmalinaH · Accepted solution]

Hi @Inactive User, this can be done by selecting "Insert Section Breaks Between Records" for the Render tool configuration.