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