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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.