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.