Row Warning
Create warnings based on number of rows
The Row Warning tool is very useful for automated testing and productionizing models. It enables you to create custom warnings based on conditions so you can highlight if something seems strange.
The Row Warning tool is typically preceded by a Filter tool to create your condition.
You can create multiple warnings in a single model
Model warnings are shown explicitly in your folders
Note that all logs messages of Models can be extracted as a table with the Less Log Connector. That means that all your custom Warnings (using the Row Warning tool) will also show up in the logs which means you can extract all your warnings at scale for monitoring performance in Less with the Less Logs Connector.
Configuration
There are two required inputs of the Row Warning tool.
Set Row Trigger
Input the number of incoming rows that should trigger a warning. If you input 1 and your incoming dataset is contains more than 1 row, then the warning will be triggered.
Input Warning
Input your custom warning message.
When To Use
The Row Warning tool is typically used for flag shortcomings of your data or to flag certain scenarios:
- It is very useful to set up warnings that inform you of data quality issues. It could be invoices with an amount lower than zero.
- The Row Warning tool takes precedent over errors. That means you can use it to overwrite errors, for example after an API tool to test if the dataset is empty. That will overwrite errors of downstream tools that except more than zero rows.
- Use the Row Warning tool to flag if certain columns are NULL
Examples
Test for Missing Fields
Test for Missing Fields
I want to create a warning if my expense_type column is NULL
Flag Cases
Flag Cases
I want to create a warning if my invoice amount is different from my purchase order amount