Applies a simple set operation on tables in its body.
Details
Merging Table Columns into Rows
The Table Set Macro allows to merge the columns of tables to merge into one row in the result table. In this case you need to use the Set Operator 'or'. You need to make sure that all columns of the resulting table are present in the first table.
This allows you to for instance generate a table by the use of the Display Table Macro and add additional information by a plain HTML table.
Suppose there is a couple of documents that describe books. For this example each book has a name (title) and the information about the author.
You need to list all books and you want to add the information, if you have read the book or if you are reading it.
The Table Set Macro does the merging of table rows. You need to select by the column 'Name' and the set operator 'or'.
The Display Table Macro lists all books.
Note that you select (Select: Name, Author|, Status|) the Status although this is not a property in the documents you are selecting. So this column will always be empty.
The information for the Status column is then added by your second table.
The name column makes the match to merge the columns of the second table into the row of the first table. The Select of the first table defines the order of representation of columns and properties.
The resulting table:
With this use case you may add information to a document listing that is not present in the documents. The difference to adding this information to the document is that you cannot select on it and cannot reuse this information in other queries. But it allows to add information that is only relevant in one specific use case.
