Boolean cards

Back to: Index of cards

Cards in this section return and display Boolean values.

• Transform table column values
• Coalesce
• Contains
• Does not contain
• Starts with
• Ends with
• Is
• Is not
• Equal to
• Not equal to
• Greater than
• Greater than or equal to
• Less than
• Less than or equal to
• Before
• On or before
• After
• On or after
• On
• Not on
• Between (inclusive)
• String to Boolean

Transform table column values

Takes a Boolean column from a transform table as input, and returns an array of the Boolean values.

Coalesce

Returns the first value that is not null, or null if all inputs are null.

Contains

Returns True if the input string contains the specified substring (case-sensitive).

Does not contain

Returns True if the input string does not contain the specified substring (case-sensitive).

Starts with

Returns True if the input string starts with the specified substring (case-sensitive).

Ends with

Returns True if the input string ends with the specified substring (case-sensitive).

Is

Returns True if input values are the same.

Is not

Returns True if input values are different.

Equal to

Returns True if the numbers are the same value.

Not equal to

Returns True if the numbers are not the same value.

Greater than

Returns True if the input number is greater than the second number.

Greater than or equal to

Returns True if the input number is greater than or equal to the second number.

Less than

Returns True if the input number is less than the second number.

Less than or equal to

Returns True if the input number is less than or equal to the second number.

Before

Returns True if the input timestamp is before the second timestamp.

On or before

Returns True if the input timestamp is on or before the second timestamp.

After

Returns True if the input timestamp is after the second timestamp.

On or after

Returns True if the input timestamp is on or after the second timestamp.

On

Returns True if the input timestamp is on the second timestamp.

Not on

Returns True if the input timestamp is not on the second timestamp.

Between (inclusive)

Returns True if the input timestamp is inclusively between the second and third timestamp.

String to Boolean

Convert literal true/false string values to their corresponding Boolean values, with all other strings set to false. Optionally, set the default Boolean value totrue and/or specify which string values will be mapped to true and/or which to false."