Changing cells height

Use case 

You need to change cells height of a given table.

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 one of the following SQL query patterns:
   - to adjust the height of a column:

   SELECT FORMATWIKI("{cell:height=100px}",T1.'Transaction_Amount',"{cell}") 
   AS 'Transaction_Amount', T1.'Service Agent'  FROM T*

   Copy

   SQL
   

   The height applied to at least one column applies to the entire table.

   - to adjust the height of a row :

   SELECT CASE WHEN T1.'Service Agent'= "Peter Jacobs" THEN FORMATWIKI("{cell:height=100px}",T1.'Service Agent',"{cell}") 
   END AS 'Service Agent', T1.'Transaction Type',T1.'Transaction Status'  FROM T*

   Copy

   SQL
   

   Pick at least one value in a row to adjust the cells height and add a conditional function such as IF, CASE WHEN, etc. paired with the FORMATWIKI function.

6. Click Next. 

7. Define the table settings and view options if needed. 

8. Save the macro and the page.