Use case

You need to gather all column headers/names through the table for further display in a table.

Solution

  1. Switch the page to the edit mode.
  2. Insert the Table Transformer macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. Switch to the SQL query tab.

  5. Enter the following SQL query:

    SEARCH / AS @TABLE1 RETURN (@TABLE1) AS @TABLE2 FROM T1;
SELECT '0' AS 'All Columns' FROM @TABLE1
  6. Save the macro and the page.

The use case is highly viable for the configs involving complex tables with numerous columns, allowing to quickly gather an aggregated display of each column header for further processing.