This version of the app's documentation is outdated. Please find the information you're looking for here: |
The default SQL query works with no need to change it:
|
In the SQL query tab in the macro browser you can find the default query:
SELECT * FROM T* |
SELECT * outputs all columns from source tables. Replace the asterisk with a comma separated list of column labels in single quotes to output only these columns in the merged table:
SELECT 'Name', 'Age' FROM T* |
FROM T* gets data from all tables within the macro body. Replace the asterisk with the number of the table to use the particular table only:
SELECT 'Name', 'Age' FROM T1 |
If you want to merge tables with different column labels, use this query example that outputs the column Job from the second table as the column Position:
SELECT * FROM T1 UNION SELECT *, 'Job' AS 'Position' FROM T2 |
In the SQL query tab in the macro browser you can find the default query:
SELECT * FROM T1 OUTER JOIN T* ON T1.'Name' = T*.'Name' |
SELECT * outputs all columns from source tables. Replace the asterisk with a comma separated list of column labels in single quotes to output only these columns in the merged table:
SELECT T1.'Name', T1.'Age', T2.'Certification' FROM T1 OUTER JOIN T* ON T1.'Name' = T*.'Name' |
OUTER JOIN T* looks up all tables. You can also use other functions:
ON T1.'Name' = T*.'Name' is the matching criteria. The rows in the merged table should match on the column Name.
If you want to join tables with different labels of columns for matching, use this query example. The rows in the joint table should match by the column Id for Table 1, # for Table 2, N for Table 3:
SELECT T1.'Id', T1.'Full name', T2.'Login', T3.'Personal space', T3.'Create space', T3.'Confluence admin', T3.'System admin' FROM T1 JOIN T2 ON T1.'Id' = T2.'#' JOIN T3 ON T1.'Id' = T3.'N' |
If you want to merge two tables by one criterion and the third table by another criterion, use this query. Table 1 matches Table 2 by Login or name, then Table 3 matches them by Level:
SELECT T1.'Full name', T2.'Level', T3.'Personal space', T3.'Create space', T3.'Confluence admin', T3.'System admin' FROM T1 JOIN T2 ON T1.'Login' = T2.'Name' JOIN T3 ON T2.'Level' = T3.'Level' |
The following table settings are available in the Table Transformer macro:
To set the settings:
The following view options are available in the Table Transformer macro:
To set the settings:
To get more options such as default sorting and row numbering, freezing the first N rows/columns and others wrap the Table Transformer macro in the Table Filter macro. |