Pattern check allows you to search for patterns in data if you don’t know the exact word or phrase you are seeking. This kind of SQL query uses wildcard characters to match a pattern, rather than specifying it exactly.
Below are the possible pattern options in uArrow:
|starts with||To search for column value beginning with the any letter.|
|ends with||To search for column value ending with the any letter.|
|contains||To search for column value with particular pattern anywhere in the column value.|
|stars with & ends with||To search for column value beginning with the any letter and ending with any letter.|
|custom||To search for column value based on certain regular expression pattern.|
If the Base Table is LINEITEM, Base Column is L_SHIPMODE, as per Pattern condition check the values should match in the base column data.
Here, if the LINEITEM.L_SHIPMODE column value does not match with specified Pattern values, then those base table records are considered as invalid.
Steps to create Pattern check rule in uArrow:
1. Click + Add button in the Pattern check rule for column L_SHIPMODE.