Table1 column replication on table2 inside table transformer

[Patidar_ Rajkumar]

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.

[Stiltsoft support]

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]

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]

Hi @Patidar_ Rajkumar ,

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

[Patidar_ Rajkumar]

Thanks for information!

I will check on this with administrator.

Thanks

Rajkumar Patidar