Skip to main content

ISEVEN Function

Returns true if the argument is an even value. Argument can be an Integer, a function returning Integers, or a column reference.

Since the function returns a Boolean value, it can be used as a function or a conditional.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

Integer literal value:

iseven('4')

Output: Returns the value true.

Column reference value:

iseven(errorCount)

Output: Returns true if the value in the errorCount column is an even number.

Syntax and Arguments

iseven(int_value)

Argument

Required?

Data Type

Description

int_value

Y

integer

This value can be an Integer, a function returning an Integer, or a column reference.

For more information on syntax standards, see Language Documentation Syntax Notes.

int_value

Name of the columns, expressions, or literals to compare.

  • Missing values generate missing string results.

Usage Notes:

Required?

Data Type

Example Value

Yes

Column reference, function, or Integer literal value

myColumn

Examples

Tip

For additional examples, see Common Tasks.

Example - Basic Equal and Notequal Functions

This example demonstrates comparison functions.

Functions:

Item

Description

EQUAL Function

Returns true if the first argument is equal to the second argument. Equivalent to the = operator.

NOTEQUAL Function

Returns true if the first argument is not equal to the second argument. Equivalent to the <> or != operator.

ISEVEN Function

Returns true if the argument is an even value. Argument can be an Integer, a function returning Integers, or a column reference.

ISODD Function

Returns true if the argument is an odd value. Argument can be an Integer, a function returning Integers, or a column reference.

In this example, the dataset contains current measurements of the sides of rectangular areas next to the size of those areas as previously reported. Using these functions, you can perform some light analysis of the data.

Source:

sideA

sideB

reportedArea

4

14

56

6

6

35

8

4

32

15

15

200

4

7

28

12

6

70

9

9

81

Transformation:

In the first test, you are determining if the four-sided area is a square, based on a comparison of the measured values for sideA and sideB:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

EQUAL(sideA, sideB)

Parameter: New column name

'isSquare'

Next, you can use the reported sides to calculate the area of the shape and compare it to the area previously reported:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

NOTEQUAL(sideA * sideB, reportedArea)

Parameter: New column name

'isValidData'

You can also compute if the reportedArea can be divided into even square units:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

ISEVEN(reportedArea)

Parameter: New column name

'isReportedAreaEven'

You can test if either measured side is an odd number of units:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

IF((ISODD(sideA) == true) OR (ISODD(sideB) == true),TRUE,FALSE)

Parameter: New column name

'isSideOdd'

Results:

sideA

sideB

reportedArea

isSquare

isValidData

isReportedAreaEven

isSideOdd

4

14

56

FALSE

FALSE

TRUE

FALSE

6

6

35

TRUE

TRUE

TRUE

FALSE

8

4

32

FALSE

FALSE

TRUE

FALSE

15

15

200

TRUE

TRUE

TRUE

TRUE

4

7

28

FALSE

FALSE

TRUE

TRUE

12

6

70

FALSE

TRUE

TRUE

FALSE

9

9

81

TRUE

FALSE

FALSE

FALSE