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

1 accepted

2 votes
Answer accepted
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.

 

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 11, 2025

Hi, thank you. Indeed, as the title suggests, I was using the "Table transformer" macro. It provides only two default options - Merge tables and Lookup tables. 

What I am looking for is to be able to have one table with all pieces in random order, and then automatically create multiple new smaller tables (one for each model) filtering out the rows with a given value in a certain column. 
Then I (or my colleagues) can add to the big table anytime we have a new piece, and it will be automatically added to the relevant "model" tables.

I tried with the Table filter macro, but there are only two options to chose from when setting up the filter: = or !=. I need also "contains".

In the end I used the Table Excerpt in combination with Table transformer macro. 

Thank you.

Suggest an answer

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

Atlassian Community Events