Returns true if the rightmost set of characters of a column of values matches a pattern. The source value can be any data type, and the pattern can be a , regular expression, or a string.

String literal example:

derive type:single value:ENDSWITH(tweets,'?') as:'hasQuestion'

Output: Writes true into the new hasQuestion column if last letter of the tweets column value is "?". 


derive type:single value:ENDSWITH(tweets,`{hashtag}{1,9}`) as:'hasHashtag'

Output: Generates the hasHashtag column containing true if the tweets column ends with 1-9 hashtag values. Otherwise, the hasHashtag column is set to false.

Regular expression pattern example:

set col:Status value:IF(ENDSWITH,myNum,/([01][0-9][0-9]|2[0-4][0-9]|25[0-5])/),'myNum - valid','myNum - error')

Output: Sets the value in the Status column to myNum - valid if the value of the myNum column ends with a value between 0-255. Otherwise, the Status column is set to myNum - error.

derive type:single value:ENDSWITH(column_any,pattern)

ArgumentRequired?Data TypeDescription
column_anyYanyName of the column to be applied to the function
patternYstringPattern or literal expressed as a string describing the pattern to which to match.


Name of the column to be searched.

Required?Data TypeExample Value
YesColumn referencemyColumn


, regular expression, or string literal to locate in the values in the specified column.

Required?Data TypeExample Value

Example - STARTSWITH and ENDSWITH Functions