Compare node

Category: Node

Version: 1.0

Last updated: November 26, 2025

Author: Any2Info

Description

The Compare node is used to detect changes between two data tables inside an Any2Info dataflow. It compares a previous result set or flow branch with the latest retrieved tables from the dataflow and determines which rows are new, updated, or removed. The tables can be selected in the property panel using the First and Second tables , both of which are required.

When executed, the node performs a row-by-row comparison based on the configured columns. It then enriches the output with a RowState value. The name of this column can be customized in the property menu.

By clicking the Configure button in the property panel, you can define which columns should be used for the comparison. These can be binded if needed. If no columns are selected, the node will compare all columns.

Property Options

Setting
Type
Required
Description

First

Select

Yes

Refers to the first table to be compared. This table serves as a baseline against which the second table is compared.

Second

Select

Yes

Respresents the second table that will be compared against the first table.

Columns

Select

No

Specifies the columns that need to be compared between the tables.

Row state column

Text

No

Specifies the column name used to store each row’s comparison state.

Configuration Options

Select the columns that need to be compared. When no columns are selected the node compares everything. There is also a possibility to filter bindings, sources and targets in this menu.

Execution Flow

Typical usage:

  • A Daily Trigger activates the flow.

  • An import node from ERP or database.

  • On top a resultset that has the newest data

  • Compare node in the middle because it needs to compare the new incoming data with the previous data

    • not empty node that says it only needs to give new or changed data from the compare node

    • Export the new or changed data to vPlan

  • Query node that gets all the data from the first resultset (with the new data)

  • Put it in a new resultset called previous data

Changelog

Version
Date
Change

1.0

November 26, 2025

Initial documentation version added.

References

  • Not empty node

  • Any2Info DataHub Guide

PreviousFunctionNextCondition

Last updated