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 #28: Formatting Financial Data

Gomes
8 - Asteroid

See my proposed solution.

wwatson
12 - Quasar

my belated solution

mollymargolis
8 - Asteroid

My solution

JethroChen
10 - Fireball
Spoiler
challenge_28_jc.PNG
nelsoer
6 - Meteoroid

solved with combination of data cleaning, dynamic rename, select, sample, append (date), and multi-row to fill down share class.

DemandEngineer
8 - Asteroid

My solution has more selects to reduce the number of fields making it easier for me to see what I'm working with... not sure if this is more efficient as well.  The solution retains all fields and uses the embedded Select in the Append Fields tool

Qiu
20 - Arcturus
20 - Arcturus

A little brutal

Spoiler
en-28.PNG
DataHabanero
9 - Comet

Awesome Possum!

JoePC
9 - Comet

Solution Attached

DanTheAnalyticsMan
7 - Meteor

Data cleansing using the multi row formula and regex