Weekly Challenges

binuacs · ‎12-16-2024

Spainey · ‎12-17-2024

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.

スポイラ

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.

Community Challenge 454 Solution.png

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.