Workflow comparing two datasets

KNIME Extensions Reporting
#1

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

#2

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