The Table Excerpt and Table Excerpt Include macros combine different kinds of table excerption and multi-excerption in one tool:
The macros improve the performance of pages storing large tables and let you use the original tables for any purpose, including filtering, building multiple charts and pivot tables.
You will be able to reference the marked table by inserting the Table Excerpt Include macro and entering the specified unique name. |
Speeding up macro entry with autocomplete: type { and the beginning of the macro name 'Table Excerpt", to see a list of suggested macros. Select the Table Excerpt macro from the prompted results. |
|
- Current page
- Specific page (specify the page title)
- Page and childpages (specify the page title)
- Page and all descendants (specify the page title)
- Pages with labels (specify the page labels and the space title)
Speeding up macro entry with autocomplete: type { and the beginning of the macro name 'Table Excerpt Include', to see a list of suggested macros. Select the Table Excerpt Include macro from the prompted results. |
You can use the Table Excerpt Include macro withing one page without showing the source table in combination with the Pivot Table and Chart from Table macros because a pivot table and a chart can be built without displaying a source table. On the other hand, if you want to use the Table Excerpt Include macro within one page in combination with the Table Filter macro you need to select the "Show a copy of the source table" checkbox because this macro requires a table for its correct work. |
Note that after changing page permissions for a user, viewing the restricted data in the Table Excerpt Include macro is still possible using the Output cached results option until this user or another with the same restrictions revisit the page. The reason for this is that the user has already viewed or exported restricted data on the page earlier. |
|
As the result, you will receive multiple charts generated on the basis of the same data table from multiple pages.
1. You need to use the following structure: Table Filter > Table Excerpt > Table if you want to reuse the source table without filters on the same or another page with the help of Table Excerpt Include.
Wrap Table Excerpt Include with Table Filter and filtration will affect its data on the page. |
2. This structure: Table Excerpt > Table Filter > Table will let you use the already filtered table on the same or another page with the help of Table Excerpt Include.
Table Excerpt > Table Filter > Table
If you want to combine data of Table Excerpt and Page Properties, you need to add a column with the page title to the table inside Table Excerpt first.
Then you need to wrap Table Excerpt Include and Page Properties Report with the Table Transformer macro and merge their data by the Title column.
If you need to merge tables that have the same column names from different pages, please do the following steps:
1. Wrap tables on different pages with the Table Excerpt macro and name them identically.
2. Insert the Table Excerpt Include macro on a new page.
3. Specify the settings:
4. Choose Show as a report table option.
5. Save the page to see the result.
Note, that if your tables have different column names, you need to use the Table Transformer macro and choose Custom Transformation for merging. |
To depict page metadata, please do the following: