Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Table transformer - split a table into several new tables based on a value in one of the columns

Zuzana Kucerova
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 10, 2025

Hello, I have a table of lego parts with their properties (shape, color, size, ...). One of the properties is "Model", which determines to which model the part corresponds (it could correspond to several models). I would like to use Table transformer to automatically split this table into several smaller tables, one for each model. So somehow the opposite of Join tables. Is this possible, please? 

Thank you.

1 answer

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2025

Hi @Zuzana Kucerova ,

It seems that you are talking about out Table Filter, Charts & Spreadsheets for Confluence app.

If this is the case, you may reuse your source table as many times as the number of your models is (each table copy for each model) with the help of the Table Excerpt/Table Excerpt Include macro.

Then you wrap each copy (each Table Excerpt Include macro) in the Table Filter macro and filter by the specific model. The filters can be easily hidden for the view mode.

Or you may use the Table Transformer macro instead of the Table Filter macro and filter your tables via the WHERE clause (SELECT * FROM T* WHERE 'Column with models' LIKE "%specific_model%").

If you are stuck or meant smth else, please refer to our support portal directly. It's confidential, and we'll be able to discuss your case in details.

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events