Replicating table and adding columns

Question

We are trying to replicate a table from one Confluence space/page (Space #1) to another Confluence space/page (Space #2), so that the table can be automatically updated in Space #2 whenever we update the table in Space #1.

In addition, we would also like to add a few more columns to the table in Space #2 for direct edits in Space #2.

1) Can we use the “Excerpt Include” macro function to replicate and link the table in Space #2?

2) Can anyone advise how to add columns for direct edits in Space #2?

Thank you.

GJ_abpfbg · Answer

If you only wanted to add a column with static data, you can do so by editing the SQL in the Table Transformer macro. This is useful if you want to place this table inside a Pivot Table macro and you want to identify the source tables. For example: SQL query: SELECT *, "" AS '' FROM T1

Natalie Paramonova _Stiltsoft_ · Answer

Hello,

I think I have a solution for your use case. The Table Filter and Charts app starting from the version 5.0.0 includes the Table Transformer macro that provides merging tables.

The steps are the following:

1. Wrap the table in Space#1 in the Excerpt or Table Excerpt (included in Table Filter and Charts) macros.

2. Insert the table in Space #2 using the Excerpt Include or Table Excerpt Include macros.

3. Wrap the Excerpt Include or Table Excerpt Include macro with the Table Transformer macro.

4. Place the second table you want to edit in Space #2 in the macro body.

5. Select the Lookup tables preset in the Table Transformer macro to merge two tables.

As a result, the merged table will be automatically updated after changing both the table in Space #1 and the table in Space #2.

Please let me know if it helps.

Choy Fong Chan · Answer

Thank you!!