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 #22: Identify Values to Aggregate

Laszlo_D
8 - Asteroid

image.png

Assaf_m
11 - Bolide

Solution Attached

kmcdaniel
8 - Asteroid
Spoiler
Challenge22.png
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_22_RODO_Solution.png
Parul_Kapoor
8 - Asteroid

Solution attached

SueDonim
8 - Asteroid

Have two solutions:

- First one almost worked, but not quite (and can't figure out why - most be a problem in the RegEx)

- Second one worked

 

Spoiler
In the first solution (top row), my RegEx expressions was "atm2.(\d*.\d+)]"
It matched on all but 6 rows and I can't see why.

Second method, replace "atm2." with "|" then split to rows by the | worked.


MySolution.PNG
mat_budden
8 - Asteroid

Hi All,

 

Please find my Result Below.

 

Spoiler
Used Regex Replace to create a Split, Split into Columns, Added Record ID then transpose, Clean up the Values with a Formula then Summarize, Joined into the answer data to confirm.

 

Thanks

Mat

ZenonH
8 - Asteroid

I fumbled with typos in my RegEx for a while, but managed to figure out how to manage to tokenize the transactions.

Spoiler
ZHSOL.png
sgrabish1
8 - Asteroid

Easy to do with guide alongside; thanks for practice exercise!

JA
6 - Meteoroid
Spoiler
Alteryx_Weekly_Challenge_22.png