Icon

S5-03-Validity

validity input(Rows: 1,104, Columns: 20)
Excel Reader
Covert date-time data to date data
Time Modifier
Load master list of valid job_code
CSV Reader
Load salary bands by job_code (min/max)
CSV Reader
Load postal prefix per province.
CSV Reader
Convert postal prefix
Number to String
Attach postal prefix for province validation.
Joiner
Validate job_code against master list(unmatched = invalid domain)
Joiner
Count violations across selected columns
Column Aggregator
Attach min/max salary for band validation.
Joiner
Keep only original columns
Column Filter
Create validity flags per rule (0=pass, 1=fail)
Expression
Export validated dataset
Excel Writer
Preview invalidated records for correction
Table View
Convert postal_codeto 5-digit text
Number to String
Extract first 2 digits of postal_code
String Manipulation
Split records into Validity(Violation count=0) and Invalidity (Violation count>0).
Row Splitter
Convert salary
String to Number

Nodes

Extensions

Links