Is there an ability to merge tabular content from multiple pages into a single page?

Rajiv Menon

Hi everyone, we have a system today where multiple teams within a program maintain individual pages with their team's information in those pages. The information is in the form of a  standard table and all teams use the same format.

Is it possible to create a master page where the information from all these pages can be merged in such a way that the master page has the same table format but with the content from all multiple pages. And also have this master page refreshed each time new content is added/updated to an individual page?

Thanks for reading and suggestions!

Ste Wright

Hi @Rajiv Menon

There are a few options:

• Include Page Macro: If the other pages just contain tables, you could use this to show each page grouped onto one. This would keep the tables separate - so not as one, summarised table. 
• Excerpt Include / Excerpt: Similar to the above for pages with more than just a table on them - you can choose to show just the table on the summary page using "Excerpt Include" and use "Excerpt" to house that data on the master pages.
• Page Properties / Page Properties Report: This is if your tables are simple summaries of a project (eg. Owner, Status, etc) rather than longer, detailed lists. See the linked Confluence page for "Page Properties" for an example

Outside of that, you'd need to consider more powerful macros from apps such as:

• projectdoc Toolbox: They have a macro called "Table Merger" allowing you merge data from different sources into one table
• Tables Filters and Charts: Which has "Table Transformers" as part of their pivot table option

There's documentation for the Apps as part of their Marketplace offering - have a look through and see which one works best for you

Ste