Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


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


In this case, you are working with a dataset that contains timestamps, which are stored in different timezones based on the location where an event or transaction occurred. However, the timestamps do not contain any timezone information.

You can use an external source of timezone information to insert timezones into your dataset. In the following example, timezones are derived based on two-letter abbreviations for U.S. state. A more accurate representation would be based on zip code zipcode data.


  1. Complete steps 1-5 in the previous section. See Perform the Lookup above. 
  2. Delete all columns except the one containing timezone information. The Time Offsets column identifies the predominant timezone in each state as an offset of the UTC timezone (Greenwich Mean Time). 
  3. Move this column to the right of the column containing your timestamps.