Is it possible to aggregate the content of multiple tables into one table?

[Deleted user]

Hey All,

my goal is to create a Confluencepage, lets call it "mainpage" herer, containing a table filled with the content of multiple other tables on different pages. I used the Page properties makro and already got to the point where i can display the content of the first row of each table in the "mainpage". How can i archieve that i get all the content from the tables?

thanks in advance for your answers and kind regards,

Felix

[Robert Reiner _smartics_ · Accepted solution]

If your use case is to merge tables which have the same columns into one large table on an overview page, you may use a user macro or a third-party app that deals with tables.

I am using our (commercial) projectdoc Toolbox that allows to merge tables by the use of the Table Merger Macro. There is a tip on our website that shows how the macros are used to merge tables from other pages: Merging Tables and Lists

If your use case is to provide metadata on pages and select on those on a page search result, you may have a look at the Document Properties Marker Macro (to define properties on a page) and the Display Table Macro (to define a query and select on those properties). The solution would be to have a page with properties for each line of your table. Then merge all tables on your overview page. I'm not sure how this can be accomplished with the Page Properties Macro (since I'm using our macros for my documentation work).

Biased alert: Please note that I am one of the authors of the projectdoc Toolbox (which is available for Confluence server).

[Jonathan Smith · Accepted solution]

@[deleted] ,

  If you are only getting 1 result from each page, then your tables need to be laid out differently.

The page properties report will only bring over the first 2 columns. Column 1 in your table will be the column header on your page properties report, while column 2 in your table will be the content.

If you had a column 3 and 4 in your table, that content wouldn't appear on your page properties report.

See example:

Page Properties

Page Properties Report

If this doesn't help, please supply a visual of your page properties table and your page properties report result.

Regards,

Jonathan

[Deleted user]

Thank you for your quick answer, so if i understand that correctly it doesn´t work with the pageproperties macro, because what you describe is exactly where i am right now, because it will only show the header and the following column or row and not further columns or rows. 

Do you know another Macro to reach the goal of including also Column 3,4,5,etc.?

Regards,

Felix

[Jonathan Smith]

@[deleted] 

In regards to column 3,4,5, I don't believe so. I am sure this is a 'want' by many users (including myself).

The only other thing I can share is if you don't like the vertical look of your table, you can have a horizontal look by using multiple page properties and multiple tables.

[Natalie Paramonova _Stiltsoft_]

Hi Felix,

The Page Properties Report macro is a great solution for one-row tables. If you need to merge any tables you want you can try the Table Filter and Charts app.

Starting from version 5.0 the app includes improved Table Excerpt Include macro that let you multi-excerpt tables from different sources (current page, child pages, pages by labels and more) and the Table Transformer macro that let you merge and transform tables using the default presets and custom SQL queries.

The steps may be as follows:

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 master 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 Table Excerpt Include and Table Transformer macros are available in Confluence Server and Data Center for now.

[Deleted user]

Hi Natalie,

Thank you for your answer, i solved it with the table transformation and excerpt macros you mentioned. 

best regards,

Felix Peter