Table visualization only when data is included

Question

Hello everyone,

I would like to copy a table from child page to parent page which can be done easily with "table excerpt" macro, but I want the table to be visualized only if there is some data inside that table.

For example if I have a parent page and under it 2 child pages and in both child pages I have a table in one of them I have some data in the table, but in the other one there is no data. I would like to visualize only the one that has data on the parent page.

Can this be achieved with some other macro/s or development needs to be done?

Vladimir Stankov · Answer

Hi,

I just resolved my problem, but I used the excerpt macro in combination with table transform macro where I write a simple SQL to define that if the fields under header are not empty to visualize the table.

Plus on the message tab in table transform macro I give a tick to "no results" to exclude even the header fields. So if there is some data in the table it will be visualized on the parent page and only then

Thank you very much

Stiltsoft support · Answer

Hi @Vladimir Stankov ,

As you've mentioned the Table Excerpt macro, I suppose you use our Table Filter, Charts & Spreadsheets for Confluence app.

Maybe the following options may give some hints how to proceed with the task.

If your tables on the child pages have the same headers, you may collect all of them into one combined report via the Table Excerpt Include macro. You may wrap each table in the Table Excerpt macro, assign the same name to all of the macros and collect them through the Table Excerpt Include macro (specify this name, choose to collect excerpts from the child pages and tick the "Show as a report" option).

As a result, you'll get a big combined report. If there is a table inside your excerpt, then it will be pulled to the report.

If the issue is that by "no data" you mean not just no table or only table headers left but empty table rows (the grid is present but there may or may not be data in the cells), you may still collect the combined report and put the Table Filter macro on top.

Via the Table Filter macro you'll be able to filter out the empty cells (set the reversed filter for empty values).