Unify and manage your data

Examples of Mixed Functions

Mixed functions are used in a data validation function.

You can mix the functions using the AND and OR operators in the following ways:
  • AND - When using the AND operator, both the functions must meet the given criteria.
  • OR - When using the OR operator, either of the functions must meet the given criteria.
Table 1. Mixed Functions
FunctionDescription
in(attributes.BirthCountry.value, 'US') and exists(attributes.SSN.value) or not(in(attributes.BirthCountry.value,'US'))The validation function checks that the SSN number is not empty if the country value is US. If the validation is met then the appropriate validation message is displayed.
gt(attributes.Age.value,'21') and lt(attributes.Age.value,'100') The validation function checks that the age value is in the range of 21 to 100. If the validation is met then the appropriate validation message is displayed.