Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
9 - Comet

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
20 - Arcturus
20 - Arcturus

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