Challenge #353: A Pokémon Tournament

[AdamH]

solution

[NMangera]

Takeaway

1.  tool: JSON Parse. does what says on the tin to extract key-value pairs

2. tool: arrange. vertically stack specific columns together (similar to union)

3. sequence: transpose post join if presented with option, as common linking field may be required to match both tables

[Tgigs]

My solution attached.

The order of my pokemon in the final output is not the same as the order in the solution. To fix this I would need to include the pokemon number so I could resort the data to its original sort order.

[adamweaver39]

Spoiler

Fun challenge! Although I'm not sure why Misty didn't make the cut on the OG output on the start file... she qualifies according to my flow! 

[jflanigan]

Spoiler

[miles33076]

Maybe my best challenge yet. However, it maybe should have been mentioned we were looking for a combination of 8 distinct types not just types alone. Since one Pokémon could have one or two types attributed. Still challenge accepted. 

[alineruizcampos]

Spoiler

 

[jacobcarman]

Spoiler

My solution

[OzlemSigbeku]

Spoiler

 

[hgayle]

Spoiler