Use case

You need to adjust the content in a column of another macro output used as a source table (e.g. Jira Issues macro, Page Properties Report, Task Report, etc.).

Solution

  1. Switch the page to the edit mode.

  2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.

  3. Select the macro and click Edit.

  4. In the Presets tab select Custom transformation and click Next.

  5. Enter the following SQL query pattern:

    SELECT *, REPLACE_VIEW(T1.'Status',"Done","Resolved") as 'Status' FROM T1 

/* SYNTAX - REPLACE_VIEW('YOUR COLUMN NAME', "SOURCE DATA TO REPLACE","NEW DATA REPLACING THE OLD") */
    SQL

  6. Save the macro and the page.

The REPLACE_VIEW function allows to not only change the content of a column, but also retain the original formatting of the source(cell) so that it could be applied to the altered output (see screenshots).