Is there a way to group results from different flows into a single table?
Solution:
The union node in ToD allows stacking tables on top of each other. With multiple files to combine as a starting source for a flow, they can be linked to a union node like this:
In the union node configuration, it is possible to merge data according to different rules. For our case, we will choose the option Intersection of input fields:
Tip
Having the same names for the columns to be stacked is preferable here. If necessary, columns can be renamed in the preparation editor, with a right-click on the field in question, or with the transformation Rename a column / group of columns.
The reference documentation for the union node can be found here.
How to merge flows into a single table?
Is there a way to group results from different flows into a single table?
Solution:
The union node in ToD allows stacking tables on top of each other. With multiple files to combine as a starting source for a flow, they can be linked to a union node like this:
In the union node configuration, it is possible to merge data according to different rules. For our case, we will choose the option Intersection of input fields:
Tip
Having the same names for the columns to be stacked is preferable here. If necessary, columns can be renamed in the preparation editor, with a right-click on the field in question, or with the transformation Rename a column / group of columns.
The reference documentation for the union node can be found here.