nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

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

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.