Send feedback
Wrangler command-line directives
Stay organized with collections
Save and categorize content based on your preferences.
This page describes the directives you can use in Wrangler.
In Wrangler Power mode (the Wrangler CLI), you can add directives
and functions to a recipe. For more information, see
Wrangler CLI Directives
and
Wrangler Functions .
Wrangler supports the following directives:
Column operations
Directive
Description
Change
Column Case
Changes column names to either lowercase or uppercase.
Changing
Case
Changes the case of column values.
Cleanse
Column Names
Sanitizes column names, following specific rules.
Columns
Replace
Alters column names in bulk.
Copy
Copies values from a source column into a destination column.
Drop
Column
Drops a column in a record.
Fill Null or
Empty
If the value is null or empty, enters a fixed column value.
Keep
Keeps specified columns from the record.
Merge
Merges two columns by inserting a third column.
Rename
Renames an existing column in the record.
Set
Headers
Sets the names of columns, in the order they're specified.
Split to
Columns
Splits a column based on a separator into multiple columns.
Swap
Swaps column names of two columns.
Set
Type
Converts the data type of a column.
Encoders and decoders
Directive
Description
Decode
Decodes a column value as one of base32
,
base64
, or hex.
Encode
Encodes a column value as one of base32
,
base64
, or hex.
Hashing and masking
Directive
Description
Hash
Generates a message digest.
Mask
Number
Applies substitution masking on the column values.
Mask
Shuffle
Applies shuffle masking on the column values.
Lookups
Directive
Description
Catalog
Lookup
Static catalog lookup of ICD-9, ICD-10-2016, and ICD-10-2017
codes.
Table
Lookup
Performs lookups into Table datasets.
Natural language processing
Parsers
Row operations
Transient aggregators and setters
Directive
Description
Increment
Variable
Increments a transient variable with a record of processing.
Set
Variable
Sets a transient variable with a record of processing.
Unique ID
Directive
Description
Generate
UUID
Generates a universally unique identifier (UUID).
What's next
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-01 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-10-01 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-01 UTC."]]