Diff node lets you identify values that have been added, removed, or updated in a source.
Add a Diff to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Diff. Note that you could work with the node in the Dataflow tab or use the Properties panel.
Follow these easy steps
After importing your source in a Dataflow, click on the node, select the Duplicate option in the node toolbar, and place the nods side-by-side.
On the left-hand node, select the previous version or the original version of the file. On the right side node, choose a more recent version.
The Diff node uses the Primary Key dropdown to select which field to use as a base for comparison. We recommend choosing a field with unique values.
There are three indicators of of changes made to data.
You could rename these labels to something more readable like created, deleted, and updated.
The last dropdown has three options to overlay data between the two sources: