Challenge #454: An Era of Costumes

[PrasadV]

I tried the same thing, but the summarize tool is not sorting the data correctly and i had to add additional steps of Sorting. Do you know why this might be happening?

[ahsanaali]

Spoiler

 

[olga_strubbe]

This was a fun challenge, thank you, @AYXAcademy!

It looks like some other folks pointed out as well, that the Costume Catalog is missing a few costume combinations.  Also, the 'Eras Challenge' input file has 'Midnight' vs 'Midnights' in Costume catalog which causes a problem when joining the data on Era. 

But this was fun, nevertheless, thank you! 

Spoiler

[Alfie_King1]

Spoiler

 

[BransonJamesFarley]

Spoiler

 

[Dhrish]

Spoiler

Solution

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

[KMan_]

Spoiler

[AnaKomissaroff]

Spoiler

[KLTerrell]

Well, as a true Swiftie, I could have made this easier by narrowing it down to either Los Angeles or Vancouver first - then noticing that Vancouver doesn't have any data included (all costume options are left null), it would have to be Los Angeles because these are the two cities that she has filmed Eras movie footage in. :)

BUT! I did it the honest way. :)

I'm sad that several of the image files associated with the SoFi stadium dates are missing from the provided image files, especially the red rep bodysuit. I thought about seeking them out and adding them, then realized I probably have better things to do with my time.

Spoiler

 

Ope, modified to add the actual reporting tools. I was so excited the blob tool worked (I've been practicing that one lately), that I didn't include the labels. 

Spoiler