Version

    5. Transformation steps

    Data set manipulation steps
    Add column
    Duplicate column
    Delete column(s)
    Rename column
    Reorder columns
    Merge columns
    Split column
    Filter rows based on formula
    Sort
    Lookup
    Calculate formula
    Text manipulation steps
    Left substring
    Right substring
    Substring
    Trim
    Pad left
    Pad right
    Normalize whitespaces
    Remove whitespaces
    Remove accents
    Lowercase
    Propercase
    Uppercase
    Remove non-alphanumeric characters
    Remove non-ASCII characters
    Remove non-numeric characters
    Remove non-printable characters
    Replace text
    Data validation (data quality) steps
    Validate against list
    Validate credit card
    Validate email
    Validate if not empty
    Validate pattern match
    Validate phone number
    Validate text length
    Validate value range
    Validate with formula
    Error handling steps
    Remove rows with errors
    Replace errors
    Replace empty values
    Clear error cells
    Math steps
    Absolute value
    Round step
    Truncate
    Square root
    Exponential
    Raise number to a power
    Natural logarithm
    Common logarithm
    Ceiling
    Floor
    Division remainder
    Date manipulation steps
    Current date and time
    Date add/subtract
    Date difference
    Get part of date
    Data conversion steps
    Convert to boolean
    Convert to date
    Convert to decimal
    Convert to integer
    Convert to string
    Convert Unix time to date
    Data anonymization steps
    Add noise to date
    Add noise to number
    Mask text
    Step and group conditions
    Conditional formulas logic
    Step conditions
    Group conditions
    Steps with condition support

    Wrangler implements a large number of steps that help you work with your data - steps that validate your date, clean it, compute mathematical formulas, and more.