Forums

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

Table1 column replication on table2 inside table transformer

Patidar_ Rajkumar
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!
July 21, 2025

Hi,

I have one table transformer, which used two table, table1 generated through JIRA and table2 has add manually have two column Key and Comment. I want all the Key from table1 to be replicated on table2 key column automatically as an when table1 JIRA get updated (Removal/addition of JIRA), while edit mode. Which will help to get all key automatically based on table1 into table2. And no need of manual addition of key in table2 to be done.

Please let me know how this can solve.

1 answer

0 votes
Stiltsoft support
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.
July 21, 2025

Hi @Patidar_ Rajkumar ,

Seems that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app.

If the final goal of your case is to join these two tables and add manual comments to the output of the Jira Issues macro, then you do everything correctly: the Jira Issues output contains keys and your manual table also contains keys that you type in. The correspondent rows are joined by the correspondent keys.

If you don't want to type in keys in the second table manually, you may take the Spreadsheet from Table macro instead of the Table Transformer macro.

Wrap your Jira Issues macro in the Spreadsheet from Table macro and your Jira output will be turned into a spreadsheet. Then you can add comments, statuses, formulas, etc. in spare columns (cells) like you do it in Excel.

Patidar_ Rajkumar
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!
July 22, 2025

Hi 

Thanks for response!

Yes, first scenario of merging table is working fine at my end but dont want to type keys in second table manually was the requirement. I was trying out using Table Transformer but could not able to achieve that requirement. 

At present, I am seeing that Spreadsheet from Table option is disable in configuration at confluence cloud. How I should be able to enable it.

 

Thanks

Rajkumar Patidar

Stiltsoft support
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.
July 22, 2025

Hi @Patidar_ Rajkumar ,

The macro can be enabled by your administrator in the Table Filter Configuration tab of the Administration section.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
ENTERPRISE
TAGS
AUG Leaders

Atlassian Community Events