Example of Data Matching

If the delimiter is turned off (not selected), any matching algorithm will compare the policy context value to the entire key column cell. For example, the first row of the column is evaluated as the string Gold,Silver and not as two values. If the policy context has a UserLevel of Bronze, the second row will match. However, the third row would not match as it would be seen as Gold,Silver,Bronze and compared to Bronze not an exact match.

Key Column Set Contains All Multiple Valued Policy Context will only return true if the key column cell contains all of the policy context information. For example, if the policy context has a UserLevel of Silver,Bronze, the first row of the column will not match, but the third row will.

Policy Context Set Contains All Multiple Valued Key Column is the opposite of the previous matching operation: The policy context information must contain all of the key column cell values. For example, if the policy context has a UserLevel of Silver,Bronze, only the second row of the column will match.

Key Column Value Set Contains Any Multiple Valued Context means that if any values in the key column cell and the policy context information are the same, the match is true. For example, if the policy context has a UserLevel of Silver,Bronze, every row of the column will match, because each row contains the same information as the Policy Context. (The policy will use the first row matched.)

Equivalence means that all values must be exact. The order does not matter; that is, Silver,Gold and Gold,Silver are the same. However, all set information must be in both values. For example, if the policy context has a UserLevel of Silver,Bronze then it does not match any row in the table because the two sets are never exact. However, if the policy context has a UserLevel of Silver,Gold,Bronze, the third row of the column will match, because the order does not matter. (If the delimiter were turned off, the operation would perform a string comparison of Silver,Gold,Bronze with Gold,Silver,Bronze which is not a match.)

Multiple Key Column Set Contains Single Value Context will give the same results as Key Column Set Contains All Multiple Valued Policy Context. However, the policy context is not separated into delimited values.

Multiple Policy Context Set Contains Single Value Key Column will give the same results as Policy Context Set Contains All Multiple Valued Key Column. However, the key column cell values are not separated into delimited values, only the policy context (if possible).

Wildcard is the intersection of the policy context with the key column call values, taking into account wildcards. For example, if the policy context has a UserLevel of Gold then the first and fourth row of the column will match. The same is true if the policy context has a UserLevel of Silver instead. However, if the policy context has a UserLevel of GOLDEN then only the fourth row will match.

Matchlist is not an available data matching operation in this example.