Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution :)
Anyone help me understand why John Coltrane wasn't 3rd on the 'output' list? (as well as other various differences ie. Missing max year? )
Also disagree with the OP's presented solution.
I don't think num-rat can be directly converted from string to number by using the select tool just once. It will omit the numbers after the comma. So in my solution, I used the cleansing tool first to remove the comma and then convert the data format. It seems many people missed this point.
Here is my take on this week challenge. I learned about the "group by / concat" option in the summarize tool !