Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Contents:


Transliterates Asian script characters from one script form to another. The string can be specified as a column reference or a string literal.

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

Column reference example:

transliterate(MyJapaneseSentences,HiraganaToKatakana)

Output: Returns the values in the myJapaneseSentences transliterated from Hiragana script form to Katakana script form.

Syntax and Arguments

transliterate(column_string,form_enum)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function
form_enumYstring (enumerated value)The transliteration form as an enumerated value. Details below.

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

column_string

Name of the column or string constant to be transliterated. String values must be in a supported Japanese script form. See below.

  • 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

form_enum

Enumerated value to indicate the transliteration to apply to the referenced column:

NOTE: Each width option can be paired with each form option. Four separate options are supported.

Enum valueDescription
HiraganaToKatakanaTransliterates Hiragana to Katagana
KatakanaToHiraganaTransliterates Katagana to Hiragana
FullwidthToHalfwidthTransliterates full-width forms to half-width form
HalfwidthToFullwidthTransliterates half-width forms to full-width form

Usage Notes:

Required?Data TypeExample Value
YesString (enumerated type)HiraganaToKatakana

Examples

Tip: For additional examples, see Common Tasks.

Example - TRANSLITERATE Function

Source:

EnglishJapanese_Hiragana
a
i
u
e
o
ka
ki
ku
ke
ko


Transformation:

The following transliterates the above characters into Katakana form:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula transliterate(Japanese_Hiragana, HiraganaToKatakana)
Parameter: New column name 'Japanese_Katakana'

The generated Katakana form is full-width. The following transliterates that column into half-width form:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula transliterate(Japanese_Katakana, FullwidthToHalfwidth)
Parameter: New column name 'Japanese_Katakana_halfwidth'

Results:

EnglishJapanese_HiraganaJapanese_KatakanaJapanese_Katakana_halfwidth
a
i
u
e
o
ka
ki
ku
ke
ko


This page has no comments.