Hi,
SQL functions in Table Transformer is limited and I am having problems to copy an entire table for each row in another table !
Table 1:
Table 2:
Table results:
Hello and welcome @david91_d
From what I know, Table Transformer does not support inserting a whole table into a single cell of another table.
The macro treats tables like a SQL dataset (AlaSQL) and operates on rows and columns. The result of a transformation is always another table where each cell contains a value (text/number/formatted content), not a nested table.
So you can: join tables, aggregate values, concatenate multiple values into one cell but embedding a full table inside a cell isn’t supported by the macro.
Have a great start Weekend ☀️
Is there a possibility to add each column content from Table 2 into a cell on each row in Table 1 ?
Hello @david91_d
Yes that part is possible.
If Table 1 and Table 2 have a common key, you can use Table Transformer to join them and bring the matching column values from Table 2 into separate cells/columns in Table 1.
Something like that:
SELECT T1.*, T2.ColumnA, T2.ColumnB
FROM T1
LEFT JOIN T2 ON T1.Key = T2.Key
That will add the values from Table 2 into the matching rows of Table 1.
The main limitation is only this: it can return values into cells, but not embed a full table inside a single cell.
Hi @Arkadiusz Wroblewski ,
I tried your query, with the remark that the matching row between tables is a column Page, means that both tables are coming from the same Confluence page, but still is not doing what I expected !
I want something like :
Hi @david91_d
Thank you for your question.
I'm part of the Table Filter, Charts & Spreadsheets for Confluence app, which the Table Transformer macro belongs to.
Based on your answers, it seems the case is more complicated, and we would need more information from you to suggest a solution.
Therefore, could you please send a message to our support team, who can assist you with the solution
@Anna Mitina _Stiltsoft_
Thank you for reaching out to him. Practically, the ones which can be most Helpful are App Vendor as they know their tool the best
Thank you for your prior help with this case.
Sometimes, other users might know the app quite well to help. But at the same time, you cannot really argue that the vendors know their app the best, especially if the case is more complicated
100 % Agree
It looks like you're new here. Sign in or register to get started.
