Boolean Formats

Boolean formatting can be used to transform values into a Boolean true/false output or to create Boolean output using logic rules. The options for Boolean output are listed in the table below.

To use these functions, the target field in the output format file should be defined as ‘Boolean’.

EXAMPLE	RESULT
%B|1	true
%B|0	false
%B|y	true
%B|n	false
%B|yes	true
%B|no	false
%B|true	true
%B|false	false

You can use logical conditions to set these formats. To use values from the coverage matrix, or a prior field in the same or a prior step, you can set conditional rules governing when to assign a specific value. In the example shown below, we have used the ‘channel’ field to set the value for the following field. Both conditions, and the associated rules, are shown.

Using conditional rules (logic) to set Boolean values is the most common way of using this formatting function, as it sets the value based on a prior condition.

Example 1: using logic to set Boolean values

Example 2: using logic to set Boolean values

The value assigned to the field is based on the assigned value in the prior field, from the business rules.

Note that if the field is not defined as a ‘boolean’ format in the output file, this format function will not work.

Boolean output for 'direction' field set using Boolean format and logic