Table Transformer is one of the macros bundled in the Table Filter, Charts & Spreadsheets for Confluence app. The macro allows you to merge and transform all kinds of tables using both automatic presets and advanced SQL queries.
Two tables with the same set of columns are merged using the Merge tables preset.
Switch to the page editor and explore the Table Transformer macro configuration.
|
Two tables with one common column are merged using the Lookup tables preset.
Switch to the page editor and explore the Table Transformer macro configuration.
|
In the SQL query tab you can add any custom query to perform complex calculations and any kind of table transformation.
You can find a list of all the available SQL functions here and more examples of custom transformation here.
In this example, we use the following query to calculate and add the Priority column based on some conditions:
SELECT *, CASE WHEN 'Subtotal' < 1000 THEN "LOW" WHEN 'Subtotal' >= 1000 AND 'Subtotal' < 2000 THEN "MEDIUM" ELSE "HIGH" END AS 'Priority' FROM T1 |
Switch to the page editor and explore the Table Transformer macro configuration.
|