SQL Table Transformer to edit JIRA table

[Katrina Atkinson]

Hello all, 

I am using the Table Transformer macro in order to modify my JIRA table within confluence. 

I would like to rename my columns. Currently it displays the field in JIRA I have pulled, however I would like the jira field to be pulled with a different column header. 

So far, I have added an SQL to edit the width of the column: 

SELECT *,
FORMATWIKI("{cell:width=700px; border-top:1px}", + 'Issues'+ "{cell}") AS 'Issues',
FORMATWIKI("{cell:width=300px; border-top:1px}", + 'Summary'+ "{cell}") AS 'Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", + 'Customer'+ "{cell}") AS 'Customer'
FROM T*

Can someone assist in how to add an SQL to Rename these columns (without duplicating the information on the table)? e.g., I would like the 'Issues' column to be named, 'dependencies'. 

Thank you!

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Katrina Atkinson,

Please check the example below:



SELECT
FORMATWIKI("{cell:width=700px; border-top:1px}", 'Issues', "{cell}") AS 'New Name for Issues',
FORMATWIKI("{cell:width=300px; border-top:1px}", 'Summary', "{cell}") AS 'New Name for Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", 'Customer', "{cell}") AS 'New Name for Customer'
FROM T*

[Dave Mathijs]

Hi @Katrina Atkinson can you confirm whether the answer helped you? In that case, thanks to click the green 'Accept answer' button.

[Felix Linh]

Hi @Katrina Atkinson nice to meet you and I would like to express my interesting in this issue.

Please modify code like below:

SELECT *,
FORMATWIKI("{cell:width=700px; border-top:1px}", + 'dependencies'+ "{cell}") AS 'dependencies',
FORMATWIKI("{cell:width=300px; border-top:1px}", + 'Summary'+ "{cell}") AS 'Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", + 'Customer'+ "{cell}") AS 'Customer'
FROM T*

Thank you,

Felix M.

[Sophia Kroening]

I tried this and the result was that all the values in the column were replaced with this text: cell:width=700px; border-top:1px. Any idea why this might be?