2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

richardzh
5 - Atom

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.

7 REPLIES 7
AmalinaH
Alteryx
Alteryx

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.

AmalinaH_0-1655914501825.png

 

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?

AmalinaH_1-1655914900712.png

 

richardzh
5 - Atom

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
13 - Pulsar

Hi @richardzh!

 

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


Thank you!

richardzh
5 - Atom

Waiting on the PDF solution...

AmalinaH
Alteryx
Alteryx

Hi @richardzh, 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.

richardzh
5 - Atom

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
Alteryx
Alteryx

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

 

AmalinaH_1-1656344227217.png

 

Labels