Page tree

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

Compare with Current View Page History

« Previous Version 2 Next »


The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

All alphabetical characters in the input value are converted to uppercase in the output value.Input can be a column reference or a string literal.

Basic Usage

Column reference example:

derive type:single value:UPPER(MyName)

Output: All of the string values in the MyName column value are written to the new column in UPPER. 

String literal example:

derive type:single value:UPPER('Hello, World')

Output: The string HELLO, WORLD is written to the new column.


derive type:single value:UPPER(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

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


Name of the column or string constant to be converted.

  • Missing string or column values generate missing string results.
  • String constants must be quoted ('Hello, World').
  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString literal or column referencemyColumn


Example - uppercase, lowercase, propercase functions


In the following example, you can see a number of input values in the leftmost column. The output columns are blank.


AbCdEfGh IjKlMnO

go West, young man!

Oh, *(*$%(&! That HURT!

A11 w0rk and n0 0play makes Jack a dull boy.


To generate uppercase, lowercase, and propercase values in the output columns, use the following transforms:

Transformation Name Edit column with formula
Parameter: Columns uppercase
Parameter: Formula UPPER(input)

Transformation Name Edit column with formula
Parameter: Columns lowercase
Parameter: Formula LOWER(input)

Transformation Name Edit column with formula
Parameter: Columns propercase
Parameter: Formula PROPER(input)


AbCdEfGh IjKlMnOABCDEFGH IJKLMNOabcdefgh ijklmnoAbcdefgh Ijklmno
go West, young man!GO WEST, YOUNG MAN!go west, young man!Go West, Young Man!
Oh, *(*$%(&! That HURT!OH, *(*$%(&! THAT HURT!oh, *(*$%(&! that hurt!Oh, *(*$%(&! That Hurt!
A11 w0rk and n0 0play makes Jack a dull boy.A11 W0RK AND N0 0PLAY MAKES JACK A DULL BOY.a11 w0rk and n0 0play makes jack a dull boy.A11 W0rk And N0 0play Makes Jack A Dull Boy.


Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 0 rates

  • No labels

This page has no comments.