Skip to main content

IN_SET

Is the value in the <NAME OF FIELD TO TEST> contained in the <COMMA SEPARATED LEST OF CORRECT VALUES> specified.

If it is then no policy text is added to the VALIDATION POLICY field. If the policy is not met then the text VALUES FAILED [<USER DEFINED LABEL>] POLICY is added to the VALIDATION POLICY field as well as appearing on the visualized output.

Syntax​

        "<USER DEFINED LABEL>": {
            "TYPE": "IN_SET",
            "PARAMETERS": "<NAME OF FIELD TO TEST>=<COMMA SEPARATED LEST OF CORRECT VALUES>"
        }

Example​

        "FRUIT CHECKER": {
            "TYPE": "IN_SET",
            "PARAMETERS": "TYPE_OF_FRUIT=APPLE, BANANA, PEAR, ORANGE"
        }

See Also​

RATIO MINIMUM

Prerequisites​

The <NAME OF FIELD TO TEST> specified in the PARAMETERS has to be in the file.