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

[Zuzana Kucerova]

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.

[Stiltsoft support · Accepted solution]

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]

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.

[Stiltsoft support]

Glad it worked out fine for you!

Regarding the Table Filter macro and "contains" option: you may set not a dropdown type of filter but a free text one on the required column.

If you use filters in the headers from the page view mode then the filter type is chosen automatically. But in the edit mode when you go to the macro settings, you can chose the required type manually.

So, the free text filter is a kind of a substitute for the "contains" option (some of the users are not familiar with SQL and prefer to use macros with a more user-friendly UI, so they choose Table Filter over Table Transformer but the end result is the same).

[Mia Tamm _Simpleasyty_]

Hi @Zuzana Kucerova,

You don’t need to split your parts table into multiple tables—instead, you can use the free Simple Table app’s “Grouping” feature to get the same effect in one place:

1. Install or open the free Simple Table app.
   
   
2. Click the Group toggle button in the toolbar.
   
   
3. Select the Model column to group by.
   
   
4. Configure each column’s behavior under grouping (e.g. show, hide, sum, average, etc.).

Once grouping is enabled, your table will collapse into one section per model, effectively giving you a “sub-table” for each model without duplicating or splitting data. You can also add filtered views on the same base table if you prefer separate views per model.

For more details on how column aggregation and grouping work, see the Simple Table docs:

https://simpleasyty.com/docs/column-aggregation/

This approach keeps all your data in sync, avoids manual joins or splits, and gives you expandable/collapsible groups—all in the free version of Simple Table. Let me know if you need any help setting it up!

— Mia Tamm from Simpleasyty