Page tree

The cloud-based product Trifacta Free is available now! Register for your free account.

 

This example demonstrates base64 encoding functions in  Trifacta Wrangler.

  • BASE64ENCODE - converts an input string to base64 encoding, with optional padding at the end. See BASE64ENCODE Function.
  • BASE64DECODE - converts an input base64encoded-string back to ASCII text. See BASE64DECODE Function.

Source:

The following example contains three columns of different data types:

IntegerFieldStringFieldssn
-2082863942This is a test string.987654321
2012994989"Hello, world."987654322
-1637187918"Hello, world. Hello, world. Hello, world."987654323
-1144194035fyi987654324
-971872543
987654325
353977583This is a test string.987-65-4321
-366583667"Hello, world."987-65-4322
-573117553"Hello, world. Hello, world. Hello, world."987-65-4323
2051041970fyi987-65-4324
522691086
987-65-4325

Transformation - encode: 

You can use the following transformation to encode all of the columns in your dataset:

Transformation Name Edit column with formula
Parameter: Columns All
Parameter: Formula base64encode($col, true)

Results - encode:

The transformed dataset now looks like the following. Note the padding (equals signs) at the end of some of the values. Padding is added by default.

IntegerFieldStringFieldssn
LTIwODI4NjM5NDI=VGhpcyBpcyBhIHRlc3Qgc3RyaW5nLg==OTg3NjU0MzIx
MjAxMjk5NDk4OQ==IkhlbGxvLCB3b3JsZC4iOTg3NjU0MzIy
LTE2MzcxODc5MTg=IkhlbGxvLCB3b3JsZC4gSGVsbG8sIHdvcmxkLiBIZWxsbywgd29ybGQuIg==OTg3NjU0MzIz
LTExNDQxOTQwMzU=ZnlpOTg3NjU0MzI0
LTk3MTg3MjU0Mw==
OTg3NjU0MzI1
MzUzOTc3NTgzVGhpcyBpcyBhIHRlc3Qgc3RyaW5nLg==OTg3LTY1LTQzMjE=
LTM2NjU4MzY2Nw==IkhlbGxvLCB3b3JsZC4iOTg3LTY1LTQzMjI=
LTU3MzExNzU1Mw==IkhlbGxvLCB3b3JsZC4gSGVsbG8sIHdvcmxkLiBIZWxsbywgd29ybGQuIg==OTg3LTY1LTQzMjM=
MjA1MTA0MTk3MA==ZnlpOTg3LTY1LTQzMjQ=
NTIyNjkxMDg2
OTg3LTY1LTQzMjU=

Transformation - decode:

The following transformation can be used to decode all of the columns:

Transformation Name Edit column with formula
Parameter: Columns All
Parameter: Formula base64decode($col)

Results - decode:

IntegerFieldStringFieldssn
-2082863942This is a test string.987654321
2012994989"Hello, world."987654322
-1637187918"Hello, world. Hello, world. Hello, world."987654323
-1144194035fyi987654324
-971872543
987654325
353977583This is a test string.987-65-4321
-366583667"Hello, world."987-65-4322
-573117553"Hello, world. Hello, world. Hello, world."987-65-4323
2051041970fyi987-65-4324
522691086
987-65-4325

This page has no comments.