We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Appending or merging PDF reports

poojamate92
8 - Asteroid

Hi Team,

 

Need a help on one requirement..

 

We have one Analytical App which is generating monthly pdf report and we have one page number count what we have build is -

 

if we run the app for Feb month and Jan month report has page count 2 then in Feb month the page count started from 3 and generate the report. If Feb month Page count is started from 3 and it has total 4 page then in Feb month page count is 7 and in next month the pdf page count start with 8.

So in this example we are getting month wise 3 outputs as -

 

1. Jan month PDF report - generate report with 2 pages (Page Seq 1 -2)

2. Feb month PDF report - generate report with 4 pages (Page Seq 3 -7)

3. Mar month PDF report - generate report with 3 pages (Page Seq 8 -11)

 

So in this case we are running workflow month wise and getting 3 separate outputs but we need output like if we are running workflow in March month then it should append the Jan - Mar month reports with page number or sequence 1 to 11 (Considering reports for Jan and Feb are already available) .

 

Please help me in this logic and suggest a way to to append these pdf reports.

 

 

4 REPLIES 4
PrashantC
Alteryx
Alteryx

@poojamate92 perhaps a way forward could be to input the individual monthly components into a Layout tool (Reporting toolbar) to arrange them in the order you want and then output that result to the PDF.

poojamate92
8 - Asteroid

@PrashantC  Thanks for responding. 

 

Can you please tell me how to input individual monthly components into layout tool?

PrashantC
Alteryx
Alteryx

@poojamate92 

- Prepare each report as a separate layout field.

- Use a Layout tool to combine the fields "Vertical with Section Breaks"

- Now you can Render the Output. 

 

Hope this helps.

poojamate92
8 - Asteroid

@PrashantC 

 

there is a little modification in logic. Do we are able to append pdf output to existing pdf output using render tool instead of overwriting to it.

 

Now the requirement is when user run workflow for April month and produce pdf report for it next time when  he run for May month the May month pdf report should merge with previous month output for Apr month.

 

Can we achieve this in any way?

Labels
Top Solution Authors