DB Concatenate Example

This workflow demonstrates the usage of the DB Concatenate node. The node allows the user combine several database queries with a similar structure into a single query using a UNION or UNION ALL statement.

The workflow splits-up an input table into three parts using the DB Row Filter. Each part gets a unique Group_ID assigned via the DB Query node. The parts are then combined into a single result which is then aggregated to get the row count per Group_ID.

External resources

• What's new in KNIME 4.6
• KNIME Database Extension Guide
• UNION (ALL) statement specification