Workflow comparing two datasets

Hello,

I'm looking for a workflow that compares two different data sets based on a unique number. I would like to see 3 outputs:

1. Combined datasets (based on a unique identifier or number)

2. Delta data from first dataset

3. Delta data from second dataset

Hi,

The easiest way to do this is via the Joiner node. For an example, see here: 

https://www.knime.com/nodeguide/etl-data-manipulation/joining-and-concatenating/joiner

After joining, you can calculate the differences using a Math Formula node.

Cheers,

Roland