Lookup rules check a field against a predefined set of data stored in a separate CSV file.
Blank records can be automatically populated using a lookalike model to complete missing data from the reference set. If blanks are not filled they can be skipped or excluded as normal.
If strings fall outside the prescribed characteristics the following options are available:
You can also easily update the reference file used by the lookup validation using the pyspotless client.
from pyspotljss import SpotlessClient spotless = SpotlessClient(access_token='<SPOTLESS TOKEN HERE>') Spotless.update_reference_rule_file(self, <RULE URL HERE>, file)
You can get the rule URL by checking all the lookup rules you have setup here: