Decode / String Layer

Decode encoded strings back to their original form using specified encoding format. Similar to Python's bytes.fromhex() or base64.decode(). Useful for:

Processing encoded data from APIs
Handling binary data stored as text
Decoding legacy data formats
Working with encrypted or encoded identifiers

Table

Select

column

The string column containing encoded data. Values must be valid strings in the specified encoding format.

Encoding

enum

Hex

Supported encoding formats for string decoding

Hex ~

Decode hexadecimal strings (e.g., 48656C6C6F -> Hello). Common in:

Binary data representation
Hash values
Color codes

Base64 ~

Decode Base64 strings (e.g., SGVsbG8= -> Hello). Common in:

Email attachments
Web APIs
Binary data in JSON

Strict

bool

true

Controls error handling behavior:

true: Raises error for invalid encoded strings
false: Replaces invalid values with null

Use true for strict data validation, false for flexible processing.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.