This guide will help you explore the Validate operation.

Validate Description

The Validate operation is designed to divide a source data into two separate tables according to a specified criteria. The first output table contains the records that meet the criteria (TRUE), while another one contains the rest of the records (FALSE).

          

Please note that the source and output tables should have the identical data structures! (The same rows, columns, and data types.) Otherwise, you need to use the Transform operation between the Validate node and output connector.

Validate Configuration

The process of configuring the Validate operation is very close to setting up the Filter node.

Filter Operation Guide

          

The Filter operation is an instance of the Validate node, where the output table consits of the TRUE records only.