Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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 #454: An Era of Costumes

AYXAcademy
Alteryx
Alteryx

Weekly Challenge LMS Banner.png

Hello Community Members,

 

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

 

This week’s challenge is all about an Era... of Costumes!

 

Unless you avoid listening to all popular music, you have likely heard of the musician Taylor Swift and her sensational world tour: The Eras Tour. This challenge celebrates the final concert of Taylor Swift’s record-breaking tour, which took place yesterday in Vancouver, Canada.

 

For those unfamiliar, The Eras Tour is a 3.5-hour concert featuring music from different eras (albums) of Taylor’s career. She performs 44 songs, divided into 9 acts, and changes costumes multiple times throughout the show.

 

Some of the featured acts are Lover, Fearless, Folklore, Speak Now, Red, Reputation, 1989, and Midnights. Each act comes with several costume options! The combinations of these costumes vary across the 149 shows represented in the provided Eras Challenge.xlsx dataset and dataset with images and URLs of the costumes worn (Costume_catalog.yxdb).

 

Your tasks for this challenge:

 

  1. Identify which costume combination Taylor wore more than once, covering all nine acts.
  2. Create a costume catalog with images for the list generated in Task 1.

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Happy solving!

 

Data Source:

Taylor Swift Style Blog

https://docs.google.com/spreadsheets/d/1caBoaDi1id6k4s1sP1bTbo846inOXzN13p0C5OrFY2E/edit#gid=3939640...

 

Image Source:

https://taylorswiftstyle.com

https://pagesix.com

 

The Academy Team

This browser version is no longer supported. Please upgrade to a supported browser.
PhilipMannering
16 - Nebula
16 - Nebula

Solution attached. Looks like I'm missing a few costumes...

Spoiler
image.png
Bobbyt23
12 - Quasar

Couldn't quite get the borders right in the layout.

 

Spoiler
Challenge 454.jpg
alexnajm
17 - Castor
17 - Castor

Done!

Spoiler
Challenge 454.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
454.jpg
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
ggruccio
ACE Emeritus
ACE Emeritus

Fun challenge! 

 

Spoiler
Used Transpose then Summarize/Concatenate to get the outfit that was worn multiple times.  Once I got the list, I used the Download tool - then Blob Convert to get a 'report snippet' of the images. Screenshot 2024-12-09 123246.png
TurboToad
10 - Fireball

Fun challenge!

Spoiler
454.PNG
balajilolla2
9 - Comet
Spoiler
Solution Attached

 

 

Jeff_Neklason
8 - Asteroid
8 - Asteroid

Fun and timely

Spoiler
454.JPG