Merge

When you merge rows and streams check the number of fields, data types and order.

Workshops

Merge stream

The Transformation underlines the ‘rules’ for manipulating data streams. Each data stream must have the same structure / layout, before they can be merged.

In this guided demonstration, you will merge datastreams based on a set of rules:

• Add constant step

Merge Streams

Merge rows (diff)

The Merge row (diff) compares the values between the merging rows and sets a ‘flag’.

In this guided demonstration, you will compare incoming records with reference records and then determine whether the record is Identical or needs updating, inserting, deleting:

• Merge rows (diff) stream

• Merge rows (diff) database

Merge Rows (diff)