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]

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.