Challenge #454: An Era of Costumes
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
binuacs
21 - Polaris
a month ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mark-spain
9 - Comet
a month ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I found this question very difficult to interpret and it was only after re-reading it a few times that the keywords "costume combination" hit me - don't get caught up worrying about the 9 acts, that part of the question seems to be irrelevant.
Spoiler
I have Transposed the costume data to rows and removed costumes that were not worn in each show. Then to find the 'costume combinations' I have grouped by city and concatenated the costume strings. By then using a Summarize tool, I find the combinations that appear more than once (1 combination). This is then split to rows and parsed out to get the Era, Type and *Colour* of the costume. I then join to the URL data before making the API Calls to reduce the amount of calls required and then convert the downloaded blob files to image report objects and add the text.
Archit_11
6 - Meteoroid
4 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dev73
8 - Asteroid
4 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tyro_abc
11 - Bolide
4 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tammybrown_tds
9 - Comet
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nSpire
9 - Comet
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ARussell34
8 - Asteroid
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Reesetrain2
9 - Comet
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Solution!
Sebastian_Chaieb2
10 - Fireball
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator