Replicating table and adding columns

[Choy Fong Chan]

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.

[Natalie Paramonova [Stiltsoft]]

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.

[GJ]

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 *, "<insert static data>" AS '<insert column name>'
FROM T1

[Dominic Lagger]

Hi @Choy Fong Chan 

1. I would say yes, you can use Excerpt Include for this. 
2. If you use Excerpt Include, you do not have the opinion to add columns only in space #2, because it is an excerpt from space#1. To add columns just in space#2, you will have to copy paste the values and make a new table

[Choy Fong Chan]

Thank you!!