How to combine two tables with no data in common, then edit combined table.

Moya Alhayek
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!
April 7, 2023

I'd like to be able to combine two tables like below 

abc
abc

 

 

xyz
xyz

 

 

To create 

abcxyz
abcxyz

 

But then be able to further edit the combined table (to add comments and such).

2 answers

4 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 10, 2023

Hi @Moya Alhayek,

@Fabio Racobaldo _Herzum_ has kindly mentioned our Table Filter and Charts for Confluence app regarding your case, so let me clarify some points.

If we are talking about native Confluence tables, the Table Excerpt/Table Excerpt Include macros can collect multiple-row tables with similar headers into one big report. The same can be done with the help of the Table Transformer macro and its standard “Merge” preset. As I see from the screenshots, your headers are different, so that is not the case.

To join tables as you’ve shown us on the screenshot, you may use the Table Transformer macro and its “Lookup” preset. But your tables (and the third one with comments that you want to add later) should have a key column with unique fields (the simplest one is a ROWNUM() function). You can’t join tables without any keys: rows coming from different tables should be somehow matched.

If you just want to combine the two tables manually and then add comments wherever you need like you can do, for example, in Excel, I can suggest our Table Spreadsheet macro. You’ll be able to store your tables on different sheets, reuse these tables using cell formulas on another sheet and type in more additional info as well.

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 8, 2023

Hi @Moya Alhayek and welcome,

unfortunately you can't do that using builtin feature. You could try some external app like https://docs.stiltsoft.com/tfac/cloud/how-to-use-table-excerpt-and-table-excerpt-include-macros-42241623.html?utm_source=atl_community

Fabio

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events