Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r078

This example illustrates how you can use functions to manipulate Unix time values in a column of Datetime type.

Source:

date
2/8/16 15:41
12/30/15 0:00
4/26/15 7:07

Transformation:

Use the following transformation step to generate a column containing the above values as Unix timecode values:

D trans
RawWrangletrue
p03Value'unixtime_date'
Typestep
WrangleTextderive type:single value: UNIXTIME (date) as:'unixtime_date'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueUNIXTIME (date)
p03NameNew column name
SearchTermNew formula

Results:

Info

NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned.

dateunixtime_date
2/8/16 15:411454946120000
12/30/15 0:001451433600000
4/26/15 7:071430032020000