How to add a blank/empty column in a Table Transformer

Question

Hi All,

I have a scenario where i'm fetching JIRA fields in a Table Transformer Table in Confluence .. so it appears/displays like a Table but once you get into EDIT mode, it shows the Table inside Table Transformer panel (not the manual Table view of rows and cols)..

Now, i want to add Columns manually (reason being.. the users who is visiting this page has to update notes etc ..in additional columns)

To my knowledge ..it is not possible it seems ..hence, reaching out here to see if any of you can help.

I have tried adding a column in the Table Transformer SQL as:

ALTER TABLE T1 ADD NOTES VARCHAR(255);

but this is not happening.

In Short,

I'm taking 3 columns from Jira to confluence. In confluence I need to add a new column and edit the column and display those changes within confluence page itself.

Ramu_kd54ib · Answer

Dear @Stiltsoft support  -> This works like a shine .. Thank you so much

Ramu_kd54ib · Answer

wow .. sounds like some solution .. this is what i wanted to hear .. some workaround ..some technique or outta box thought ..

let me try and definitely post the outcome here  :)  ..

Cheers n Thanks

Stiltsoft support · Answer

Hi @Ramu ,

If you are talking about the Table Transformer macro provided by our Table Filter, Charts & Spreadsheets for Confluence app, then you may use the following workaround:

* Put two tables inside your Table Transformer macro: Jira Issues and manually created table
* In the manually created table name one column as "Key" (identically to the "Key" column coming from the Jira Issues macro) and use other columns for additional data
* Go to the Table Transformer macro and use the standard Look Up preset to join these two tables by the unique "Key" column
* When you need to add some data for the specific issue, type in its Key in the second manually created table and leave comments in other columns
* When the page is published, you'll see one big table with Jira Issues and additional columns coming from the manually created table

Hope this helps your case.