How to actually use the Validator transformation
The Validator transformation can be a bit non-intuitive to use - even I get puzzled sometimes. But there's a small trick I use to make it much easier to understand.
Before I place the Validator transformation in my pipeline I add a SQL Query transformation - which I use to get the number of rows in the data flow.
The SQL Query transformation uses the below query. Where the output column in row_count.
Then, in the Validator transformation I can create rules that are much easier to understand.