Use case

You need to gather/merge data of multiple columns in a single one across the rows.

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:

    SELECT
   *,
   (
      'First name' + " " + 'Last name'
   )
   AS 'Full name' 
FROM
   T1
  6. Click Next.
  7. Set the worklog settings.
  8. Save the macro and the page.

If your source table columns happen to have some formatting applied which you intend to keep after the columns merge CONCAT_VIEW function is the best way to ensure that, allowing to not only perform the merge but also retain the original formatting of a column&cell, including links. 

SELECT CONCAT(T1.'Surname'," ",T1.'Name') as 'FORMATTING LEFT',
CONCAT_VIEW(T1.'Surname'," ",T1.'Name') as 'FORMATTING RETAINED' FROM T1


  • No labels