Start Free

Speed up your data preparation with Designer Cloud powered by Trifacta

Free Sign Up
 
All Templates

Work with Time Series Data with Flexible Granularity

Time series data parsing from timestamp Flow The flow view of this template

Extract or compute data values at different granularity of times with time series data

Transformations:
datetime functions (unixtimeformat), array and object functions (listif, unnest)

This template shows how you can work with time series data that’s expressed in timestamp format and identify last value at a lower granularity (milliseconds) when rolled up to a higher granularity (seconds).

It makes use of several array functions such as listif and unnest. This technique can be reused to work with any other time series data when you wish to extract or compute values at different granularity levels.

USE IN TRIFACTA USE IN DATAPREP

New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep