Chapter 2. Boolean and String Transforms

Chapter 2. Boolean and String Transforms
Prev		Next

Boolean Transform

Data in Boolean type can be converted to String or Integer (1 for "true", and 0 for "false"). You can also perform the following operations:

And

This operation applies to at least two selected fields. It follows the logical operation rules for the "And" operator. After selecting the field to operate on, specify other field names following the "A,B,C" syntax.

Field A	Field B	Output
true	true	true
false	true	false
true	false	false
false	false	false

Discard

This operation discards the rows that contain the "true" value in the selected field.

The following table shows an example of the input:

Field 1	Field 2
1	false
2	true
3	true
4	false

The following table shows the output:

Field 1	Field 2
1	false
4	false

Not

This operation applies to at least two selected fields. It follows the logical operation rules for the "Not" operator.

Input	Output
true	false
false	true

Or

This operation applies to at least two selected fields. It follows the logical operation rules for the "Or" operator. After selecting the field to operate on, specify other field names following the "A,B,C" syntax.

Field A	Field B	Output
true	true	true
false	true	true
true	false	true
false	false	false

Retain

This operation retains the rows that contain the "true" value in the selected field.

The following table shows an example of the input:

Field 1	Field 2
1	false
2	true
3	true
4	false

The following table shows the output:

Field 1	Field 2
2	true
3	true

To either

This operation enables you to specify new values (for example, "Yes" and "No", or "Success" and "Fail") for "true" and "false", and displays the result according to your input.

Input	Values	Output
true	true="Yes", false="No"	Yes
false	true="Yes", false="No"	No