We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #368: Time Zones

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here. 

 

To solve this week’s challenge, use Designer Desktop, Designer Cloud Trifacta Classic or Designer Cloud, Designer Experience.  Time_Zone_Globe.png

 

Imagine you work for an international company and have colleagues in locations around the world. You need an easy way to remember how many hours ahead or behind the time is at their location. Using a time zone table from Wikipedia and a list of cities where your coworkers live, you want to produce a list of the time differences between city pairs. 

Using the dataset and the table provided, complete the following task: 

Determine the time difference between each pair of cities in your output. Each city pair should be listed twice, with the correct time difference either ahead or behind. Your output should look like this.  

 

 

ATTENTION Designer Cloud Developers: The solution in Designer Desktop looks like this: 

AYXAcademy_0-1682346109104.png

 

 

Christina_H
14 - Magnetar

Here's my solution

Spoiler
Christina_H_0-1682347593865.png
PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
PhilipMannering_0-1682347957590.png

 

And in the Python Tool,

Spoiler
PhilipMannering_0-1682349502523.png

 

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1682348492888.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1682348998259.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Had to figure out that the symbol representing negative was "−" and not "-".  

 

Spoiler
ggruccio_0-1682349627008.png

 

Milanz
8 - Asteroid

my solution ;-)

 

Spoiler
Milanz_0-1682349730840.png

 

WesCannon
Alteryx
Alteryx

I think the results are a little different in Desinger Cloud but here is my solution!

 

Spoiler
WesCannon_0-1682350363952.png

 


 

nSpire
8 - Asteroid
Spoiler
nSpire_0-1682350899814.png

 

lanclot23
7 - Meteor

Fun one