Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Replicating table and adding columns

Choy Fong Chan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 17, 2019

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.

3 answers

2 votes
Natalie Paramonova [Stiltsoft]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 29, 2019

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.

2019-03-29_11h37_24.png

 

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

2019-03-29_11h38_57.png

 

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

2019-03-29_11h39_48.png

 

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

2019-03-29_11h40_14.png

 

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

2019-03-29_11h40_37.png

 

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

2019-03-29_11h41_17.png

 

Please let me know if it helps.

1 vote
GJ
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 27, 2023

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:

Screenshot_20230228_014032.png

SQL query:

SELECT *, "<insert static data>" AS '<insert column name>'
FROM T1

1 vote
Dominic Lagger
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2019

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 18, 2019

Thank you!!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events