Dataflows

Unions Joins

In the join step we have already learned how to link two tables together. The Union step is also about linking, but the principle is different, because in the Union the data is attached rather than linked. As the following picture shows, the Union step is quite primitive. It only requires that the table to be appended be specified. All columns of the table to be appended for which the name and data type match are appended to the corresponding column of the original table. If the column name or the data type does not match, the column is ignored. If the column names/types do not match perfectly, they must first be renamed or reformatted.

Union Join

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit www.peakboard.com

Find out all about Peakboard and browse our different use cases and success stories.