Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution 🙂
Al Bundy would be proud of us!
There's a few issues though I'd like to point out:
- As mentioned by others, there's some duplicate IDs. One entry appears a total five times, and another two times. They have different IDs now which could cause problems!
- I am not sure why the size "S" was removed in row 192 of the solution?
- row 1533 has already been mentioned by others, this is an interesting case! the original entry is "Lite Grey / Lite Grey / White / Lite Grey". If you ever shopped for shoes and paid attention, then you can conclude that these are most likely two color entries, 'Lite Grey / Lite Grey' and 'White / Lite Grey'. So it's neither 3 or 4 but 2 colors. This would need manual fixing for now (or a very sophisticated logic - not advised for just one case!).
Did anybody else remove 1 duplicate and only got 1999 records?
id = AWpiCHeBJbEilcB6P66J seems to be included in the solution set twice 🙂
Used 'Tile Tool' to make sure the IDs were unique instead of the commonly used 'Record ID' tool.
Found this one relatively straightforward. Was stuck initially on whether to draw out repeated IDs, but given output didn't seem to do that.