Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Contents:

   

Returns true if the first argument is equal to the second argument. Equivalent to the = operator.
  • Each argument can be a literal String, Integer or Decimal number, a function, or a column reference.

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

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Comparison Operators.

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

if(equal(errorCount, 0),'ok','Error_recorded')

Output: If the value in the errorCount column is zero, then the status column value is ok. Otherwise, the value is Error_recorded

Syntax and Arguments

equal(value1, value2)


ArgumentRequired?Data TypeDescription
value1YstringThe first value. This value can be a String, a number, a function, or a column reference.
value2YstringThe second value. This value can be a String, a number, a function, or a column reference.

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

value1, value2

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

  • Missing values generate missing string results.

Usage Notes:

Required?Data TypeExample Value
YesColumn reference, function, or numeric or String valuemyColumn

Examples


Tip: For additional examples, see Common Tasks.

Example - Basic Equal and Notequal Functions

This example demonstrates comparison functions.

Functions:

ItemDescription
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:

sideAsideBreportedArea
41456
6635
8432
1515200
4728
12670
9981

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:

sideAsideBreportedAreaisSquareisValidDataisReportedAreaEvenisSideOdd
41456FALSEFALSETRUEFALSE
6635TRUETRUETRUEFALSE
8432FALSEFALSETRUEFALSE
1515200TRUETRUETRUETRUE
4728FALSEFALSETRUETRUE
12670FALSETRUETRUEFALSE
9981TRUEFALSEFALSEFALSE

See Also for EXAMPLE - Comparison Functions Equal:

See Also for EQUAL Function:

Error rendering macro 'contentbylabel'

parameters should not be empty

 

  • No labels

This page has no comments.