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

Challenge #338: Let's Summarize!

Michael_Dooley
6 - Meteoroid

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?

 

 

 

 

Spoiler
Michael_Dooley_0-1664220261456.png

 

leebria3
8 - Asteroid

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.

 

Spoiler
leebria3_0-1664221223125.png

 

Clifford_Coon
11 - Bolide

My Solution: 

The First/Last year in the provide result seem to be in the row order not year order.

Spoiler
Challeng_338.jpg

TurboToad
10 - Fireball

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.

 

Spoiler
TurboToad_0-1664223456783.png

 

Pawel_Paleczny
9 - Comet

Quite different result :)

rachel_lynch
Alteryx
Alteryx

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())

Spoiler
rachel_lynch_0-1664227659325.png

 

 

Rachel Lynch
Qiu
21 - Polaris
21 - Polaris

I also noticed discrepancies with the provided resutls.

Spoiler
challenge_338.png
balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1664249741532.png

 

lugesy
8 - Asteroid

My outputs are also not matched exactly with the start file's outputs.

 

338_output_records.png

 

 

DanFlint
8 - Asteroid
Spoiler
DanFlint_0-1664267451578.png