Overview

This node splits the input data into three categories: new items, updated items, and old items based on a unique identifier field. It is useful for workflows that need to track changes in data over time, such as synchronizing records, detecting updates, or filtering out unchanged data. For example, it can be used to process a list of user records and separate newly added users, users with updated information, and users that remain unchanged.

Use Case Examples

1. Synchronizing a database by identifying new, updated, and unchanged records.
2. Processing incoming data streams to detect changes and trigger specific actions only for updated or new items.

Properties

Output

JSON

• new - Array of new items that were not previously seen.
• updated - Array of items that have changed since the last execution.
• old - Array of items that have not changed since the last execution.

Troubleshooting

• Error if the identifier field value is not unique among the input items. The error message will indicate which ID is duplicated. To resolve, ensure all input items have unique values for the specified ID field.
• If the node is set to continue on fail, it will output an error object in the 'new' output for the failed execution instead of stopping the workflow.