Challenge #368: Time Zones

[AYXAcademy]

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.  

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: 

[Christina_H]

Here's my solution

Spoiler

[PhilipMannering]

Solution attached.

Spoiler

And in the Python Tool,

Spoiler

[MilindG]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

[ggruccio]

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

Spoiler

[Milanz]

my solution ;-)

Spoiler

[WesCannon]

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

Spoiler

[nSpire]

Spoiler

[lanclot23]

Fun one