Page tree

Trifacta SaaS


Contents:

 

Contents:


Returns true if the second string evaluates to be an exact match of the first string. Source values can be string literals, column references, or expressions that evaluate to strings.

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

String literal reference example:

exact('a','a')

Output: Returns true, since the values are identical.

String literal reference example:

exact('a','A')

Output: Returns false, since the capitalization is different between the two strings.

Column reference example:

exact(string1,string2)

Output: Returns the evaluation of string1 column values being exact matches with the corresponding string2 column values.

Syntax and Arguments

exact(string_ref1,string_ref2 [,ignore_case])


ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function
ignore_caseNstringWhen true, matching is case-insensitive. Default is false.

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

string_ref1, string_ref2

String literal, column reference, or expression whose elements you want to compare based on this function.

Usage Notes:

Required?Data TypeExample Value
YesString literal, column reference, or expression evaluating to a stringmyString1, myString2

ignore_case

When true, matches are case-insensitive. Default is false

NOTE: This argument is not required. By default, matches are case-sensitive.

Required?Data TypeExample Value
NoString literal evaluating to a Boolean'true'


Examples

Tip: For additional examples, see Common Tasks.

Example - Simple string comparisons

The following example demonstrates functions that can be used to compare two sets of strings. These functions include the following:
  • STRINGGREATERTHAN - Evaluates to true if the first string is greater than the second string. See STRINGGREATERTHAN Function
  • STRINGGREATERTHANEQUAL - Evaluates to true if the first string is greater than or equal to the second string. See STRINGGREATERTHANEQUAL Function.
  • STRINGLESSTHAN - Evaluates to true if the first string is less than the second string. See STRINGLESSTHAN Function.
  • STRINGLESSTHANEQUAL - Evaluates to true if the first string is less than or equal to the second string. See STRINGLESSTHANEQUAL Function.
  • EXACT - Evaluates to true if the first string is an exact match with the second string. See EXACT Function.

Source:

The following table contains some example strings to be compared. 

rowIdstringAstringB
1aa
2aA
3ab
4a1
5a;
6;1
7a a
8aaa
9abcx

Note that in row #6, stringB begins with a space character.

Transformation:

For each set of strings, the following functions are applied to generate a new column containing the results of the comparison.

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula STRINGGREATERTHAN(stringA,stringB)
Parameter: New column name 'greaterThan'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula STRINGGREATERTHANEQUAL(stringA,stringB)
Parameter: New column name 'greaterThanEqual'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula STRINGLESSTHAN(stringA,stringB)
Parameter: New column name 'lessThan'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula STRINGLESSTHANEQUAL(stringA,stringB)
Parameter: New column name 'lessThanEqual'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula EXACT(stringA,stringB)
Parameter: New column name 'exactEqual'

 

Results:

In the following table, the Notes column has been added manually.

rowIdstringAstringBlessThanEquallessThangreaterThanEqualgreaterThanexactEqualNotes
1aatruefalsetruefalsetrueEvaluation of differences between STRINGLESSTHAN and STRINGGREATERTHAN and greater than versions.
2aAtruetruefalsefalsefalseComparisons are case-sensitive. Uppercase letters are greater than lowercase letters.
3abtruetruefalsefalsefalse
Letters later in the alphabet (b) are greater than earlier letters (a).
4a1falsefalse
true true false
Letters (a) are greater than digits (1).
5a;falsefalsetruetruefalseLetters (a) are greater than non-alphanumerics (;).
6;1truetruefalsefalsefalse

Digits (1) are greater than non-alphanumerics (;). Therefore, the following characters are listed in order of evaluation:

Aa1;
7a afalsefalsetruetruefalseLetters (and any non-breaking character) are greater than space values.
8aaatruetruefalsefalsefalseThe second string is greater, since it contains one additional string at the end.
9abcxtruetruefalsefalsefalseThe second string is greater, since its first letter is greater than the first letter of the first string.

This page has no comments.