I want to aggregate the table from different pages to summary page

[Siva]

I am having two different page, each page has table of same header. In the summary page i want to merge the other two page table content as a aggregate table.

[Natalie Paramonova _Stiltsoft_]

Hi Siva,

I have a solution for you. You can use the combination of the Table Excerpt Include and Table Transformer macros. Table Excerpt Include provides an ability to pull any tables from child pages, from specific pages, from pages by labels and more. Table Transformer merges all the tables in one.

1. Insert the Table Excerpt macro, set the Excerpt name parameter, and place the tables (or the macros outputting tables) within the macro body on every page.

2. Add the Table Excerpt Include macro on the summary page, specify Excerpt name and select an appropriate Excerpt source.

3. Wrap the Table Excerpt include macro in the Table Transformer macro, use the default presets or custom SQL queries to merge all the tables in one.

The macros are available only in Server and Data Center versions of the app for now.

[George Ivanov]

Hi Siva,

there is another macro that can help - SQL-Powered Table Transformer:

https://marketplace.atlassian.com/apps/1219300/sql-powered-table-transformer

[Robert Reiner _smartics_]

I assume that you need the assistance of a User Macro or a third-party add-on.

The (commercial) projectdoc Toolbox provides macros to deal with tables. 

Here is a tip on how the projectdoc Toolbox allows to merge tables and lists: Merging Tables and Lists

You'll also find products by other vendors on the Atlassian Marketplace that are more focussed on uses case with tables. I would like to recommend to check out these specialized third-party solutions by other vendors, since the projectdoc Toolbox's main concern is the support of dynamic lists and transclusion. Use cases with tables are along these main features. Unfortunately I cannot recommend one particular product, since my simple use cases are fully covered by the Table Merger Macro. 

Biased alert: I'm one of the authors of the projectdoc Toolbox. The projectdoc Toolbox is available on the Marketplace for Confluence Server.

[Jivan Roquet]

Same problem here, Interested in a solution as well.