Table Transformer - Copy content of a table into a row cell from another table

[david91_d]

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:

[Anna Mitina (Stiltsoft)]

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 :)

[Arkadiusz Wroblewski]

@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 :)

[Arkadiusz Wroblewski]

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 ☀️ 

[david91_d]

Is there a possibility to add each column content from Table 2 into a cell on each row in Table 1 ?

[Arkadiusz Wroblewski]

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.

[david91_d]

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 : 

[Arkadiusz Wroblewski]

@david91_d 

Thanks, now it is clearer what you want.

In that case, a simple JOIN will not produce the expected output, because it will create multiple rows per Page.

What you need is keep one row for each Page from Table 1 then aggregate / concatenate the matching rows from Table 2 into the relevant columns

Bringing the values over is possible, but not as a true nested table inside one cell.
It has to be done as grouped text output inside the cells.

So the solution is not just JOIN, but rather JOIN + GROUP BY + concatenation.