i have table create from table transformer, how can i input more data on that table with empty colum

[Pham Ngoc Tuong]

i have table create from table transformer, how can i input more data on that table with empty columm i consolidated from 2 table from table transformer

[Clara Vega _Simpleasyty_]

Hi @Pham Ngoc Tuong

It sounds like the real need here is not just consolidating tables, but having a final table that stays editable so users can add extra values manually.

In that kind of workflow, a solution based on Simple Table could make more sense than working with a transformed output, because users can keep editing a native Confluence table directly and still get enhanced table features on top.

[Mercy]

The Table Transformer macro doesn’t support manual editing of the merged output table. It only renders the result from its input tables based on the SQL-like query you define in the macro body. To add more data or fill empty columns, you must edit one of the source tables feeding the transformer or extend the transformation query to join additional static data or calculated columns. For example, you can insert a new input table macro with the extra rows you need, then update the query in Table Transformer to combine all three sources using `UNION` or `JOIN` syntax depending on your layout.

[Stiltsoft support]

Hi @Pham Ngoc Tuong ,

@Mercy has kindly guided you in the right direction - we can only add that the Table Transformer macro belongs to our Table Filter, Charts & Spreadsheets for Confluence app.

So, you may refer to our support portal directly. The portal is confidential, you are free to provide your current set up and we'll help you with the SQL query.

Meanwhile, you may check this example about table joining from our documentation - hope it helps your case.