convertunix

Convert a UNIX timestamp into an easy-to-read datetime format.

Introduction

Use the convertunix enrichment instruction to convert a UNIX timestamp into an easy-to-read datetime format.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Fields

Enter the name of the column containing the UNIX values to convert.

As Date

Select this option to return the UNIX time as a date value only. Leave unselected to return the UNIX time as date and time.

Fail on Error

Select this field to stop the enrichment instruction if the conversion cannot be applied.

Errorvalue

Enter the value with which to populate the field if an error occurs.

Example

Enrichment configuration

Fields

Campaign Start Date

As Date

Leave this field unselected.

Data tables before enrichment

Campaign	Campaign Start Date
Brand	1546344000
Outreach	1547569800
Organic Growth	1549022400

Data after before enrichment

Campaign	Campaign Start Date
Brand	Jan. 1, 2019, noon
Outreach	Jan. 15, 2019, 4:30 p.m.
Organic Growth	Feb. 1, 2019, noon