There is also a "union" function that can be used to concatenate two tables (as you might already be doing using comprehension tables).
There are two syntaxes to use it :
- table AB = union(tableA,tableB), which will use the tableA to define the columns in the resulting union
- table AB = union(tableA,tableB) schema XXX, which will generate a table that matches the columns of the schema
There is also a "union" function that can be used to concatenate two tables (as you might already be doing using comprehension tables).
There are two syntaxes to use it :
- table AB = union(tableA,tableB), which will use the tableA to define the columns in the resulting union
- table AB = union(tableA,tableB) schema XXX, which will generate a table that matches the columns of the schema
See https://try.lokad.com/s/union_example for an example