Dynamically creating contents pages using the Reporting Tools for PDF

[IraWatt]

Hi all,

I have multiple Table Tools sometimes one table could span over two pages in a PDF. I am looking for a way to create a contents page which will adjust based on how many/which pages a table covers. If anyone could share any guides or information on this, it would be really helpful.

All the best,

Ira

[AndrewSu]

@IraWatt , do you have an example workflow and an example of the desired output?  

Having that information would help tremendously to work towards a solution together. 

As a start, you can check out the 'Reporting' section in the article below to learn more best practices and how-to's.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593 

If the article above provides enough to resolve the issue, please mark this post as the "solution" so that other's in the community can benefit from our collaboration. 

Thanks. 

[IraWatt]

Hey @AndrewSu,

Thanks for getting back, would there be any section of the tool mastery to look at? The table section doesnt go into getting page numbers. All I could find is the special tags can be use to get the page numbers but that only seems to populate after rendering the PDF. Here's an example for context:

Table 1 has a 50/50 chance of covering 1 or 2 PDF pages. Is there any way to create a contents page which will change depending on the size of the data changing (in this case randomly).

If for instance table 1 has 63 records the contents page should say Table 1: page 1,2

If table 1 has 62 records the contents page should say Table 1: page 1

Hope that makes sense, I have attached the example. 

[AndrewSu · Accepted solution]

Hello @IraWatt .  Thanks for that information.  

Given your requirements, I tweaked the workflow you shared with few more steps and I believe it outputs what you are looking for. 

Note that the Formula tools AFTER the Generate Rows tools need to be updated based on how many pages you expect to have in the Input data.  I only parsed the data up to 3 pages, but theoretically it can be many more pages (I know you said it is 50/50 chance it is either 1 or 2 pages, but in the off chance that it it becomes more than 2 pages, this is the tool you'd need to update).  

Please see the attached workflow and let me know if this is what you are looking for. 

If this resolves your issue, please mark this post as the solution so that other's in the community can benefit from our collaboration. 

Thanks!

[IraWatt]

Awesome example thanks @AndrewSu