Concatenating data (union)

Merging up to 5 datasets having same fields/columns. You can use multiple concat steps in case you have 5+ datasets to merge.

Objective

Sometimes you have same data in two different sources. Getting data in a single source can be frustrating in Excel. If you know SQL you can use a UNION.

Solution

In Ananas you don't need to know how to write Excel formulas or SQL queries to concatenate two sources. And once you've built a data flow it's automatically repeatable whenever new data comes in. To concatenate your multiple data sets you can use a “union” step.