How can I create an auto-fill table from another table?

Question

Hi Community!

I would like to create a table which will summarize the content of another table. 
The base table has a plenty of rows and columns which only few of them I would like to present in the summary table. I know the Page Properties/Page properties report, but it's only useful for table of content with only two columns. Is there another clever way to do it?

Any advice highly appreciated.

Clara Vega _Simpleasyty_ · Answer

Hi @Marta Lewandowska

I’m not sure there is a native way to create a second table that auto-populates from another table in Confluence.

A different approach could be to keep a single source table and use Simple Table on top of it. That works well when the real goal is to present a cleaner summary view of a larger table.

For example, with Simple Table you can:

* hide non-relevant columns,

* sort and group the data,

* add calculated columns when needed.

So it would not be a “table generated from another table” workflow, but it could still solve the presentation side of the problem if the user mainly wants a simpler view of the same dataset.

Stiltsoft support · Answer

Hi @Marta Lewandowska ,

We don't think that it is possible natively, so you may look into 3rd party apps.

For example, we develop the Table Filter, Charts & Spreadsheets for Confluence app, that may help your case:

* To collect multiple-row tables in a big combined report (or to reuse tables), use the Table Excerpt/Table Excerpt Include macros. They serve as an advanced version of the native Page Properties/Page Properties Report macros
* To leave only required data, use the Table Filter macro on top of the Table Excerpt Include macro (filter out the unnecessary rows and hide the unwanted columns)

This is just a general option based on your initial question but please refer to our support portal that is confidential - you may share your real case and we will guide you through it step by step.

Marta Lewandowska · Answer

Yes, exactly. The problem here is extracting data from a big table of content.