Decode a Column

Replaces encoded text (base64 or URI) with its decoded counterpart.

Example

uri
%21%22%C2%A3Value1%23
https%3A%2F%2Fweb.com%2F

Decode as URI

uri
!”£Value1#
https://web.com/

blob
RGVjb2RlZCBWYWx1ZQ==
VGVzdA==

Decode as Base64

blob
Decoded Value
Test

Configuration

Column

Select a column from the table to decode.

Decode Type

Select URI or Base64 to specify the type of encoding. See examples above.

Where

Add a condition to specify when the transform should be applied. If this condition is not met for a row, the value in the selected column will remain encoded.

Screen Shot of configuring the Decode transform