Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I didn't match results but think I have the right answer...
Why no love for John Coltrane and his 12 albums?
Album years differ as well but reconcile to data. Solution has odd results like first year = 1996 and last year = 1983?
Here is my solution.
My result doesn't exactly match with the suggested output due to 'John Coltrane', but wanted to share what I think the result should be.
My Solution:
The First/Last year in the provide result seem to be in the row order not year order.
Not sure what the note was supposed to mean since I didn't see any results without a year value. Output didn't exactly match but captured the ask.
I do not return any null release years using this formula:
IIF(REGEX_Match(Right([rel_date],4),"\d{4}"),Right([rel_date],4),Null())
My outputs are also not matched exactly with the start file's outputs.
