How to do I import table information from multiple children pages into one table on the parent page

[gary_seminara]

I have multiple pages where there is a table with a column with status that I want to rollup the status into a single table on the parent page.

 Will the table and charts for confluence add-on help me do this?

[Sayed Bares _ServiceRocket_ · Accepted solution]

@gary_seminara This is a classic use case for the native Confluence Cloud Page properties and Page Properties Report macro.

However, if you want to do it with table and charts for confluence add-on  then I think this article is a good start:

• https://docs.stiltsoft.com/tfac/cloud/how-to-use-table-excerpt-and-table-excerpt-include-macros-42241623.html

[Stiltsoft support]

Hi @gary_seminara ,

Indeed, as @Sayed Bares _ServiceRocket_ has kindly mentioned, the Table Excerpt/Table Excerpt Include macros will do the trick - they work like an advanced version of the Page Properties/Page Properties Report macros.

For example, the standard Page Properties/Page Properties Report macros allow you to collect only one-row tables (if you use multiple-row tables, only the first row will be collected, other rows will be ignored). And our macros are able to built master reports from multiple-row tables as well.

Further this master report can be filtered/aggregated/visualized with the help of other macros provided by the app.

If you are not familiar with the plugin, we can suggest booking a live demo - we'll be happy to discuss your use cases.

[gary_seminara]

Thanks! that is what I found out with the  Page properties and Page Properties Report macro. I did end up using the able Excerpt/Table Excerpt Include macros as well as using the Table Transformer with some custom SQL code to get the table I wanted.  It seemed to work great!

I do have one more question though. I made the table, but I was also wondering if there was a way I could add hyperlinks to the Column titles so that when I click in the master table it brings me to the children page associated with that column. I have not been able to find a way. 

[gary_seminara]

Here is my SQL code to make the table I want which works great, I am just curious how I add a hyperlink to 'Source Table 1"

SELECT
T1.'Requirement' AS Requirement,
T1.'Status' AS 'Source Table 1',
T2.'Status' AS 'Source Table 2',
T3.'Status' AS 'Source Table 3'
FROM
T1
JOIN
T2 ON T1.'Requirement' = T2.'Requirement'
JOIN
T3 ON T1.'Requirement' = T3.'Requirement';

[Stiltsoft support]

Hi @gary_seminara ,

You can't add hyperlinks to the column titles.

Not sure why you need the Table Transformer macro in the first place. If you have standardized tables inside every Table Excerpt, you just tick "Show as a report table" option inside the Table Excerpt Include macro and all your collected tables will be merged into one table automatically.

Then if you need to show the Page title of the source page (a hyperlink), you go to the "Show page metadata" field and choose the "Page" option.

For example:

1

|Requirement |Status |

|ISO-1            |Green  |

2

|Requirement |Status |

|ISO-2            |Green  |

3

|Requirement |Status |

|ISO-3            | Red    |

->

Page                |Requirement |Status |

Source page 1 |ISO-1            |Green  |

Source page 2 |ISO-2            |Green  |

Source page 3 |ISO-3            |Red     |

If required, you may wrap the Table Excerpt Include macro in the Table Transformer macro to rename your columns and/or to list the specific columns that you want to show if your source tables have a lot of optional columns.