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

TKSnider
8 - Asteroid

Pretty straight forward on this one I thought.  I think I would of done some more alterations IF I were doing this for a production environment.  Some extra conversions here or there type of thing to make it more usable by BI systems.  Either that, or I would of used the output as the input of a secondary process to do those kinds of transformations, validations and such.

 

My solution is below.

Erin
9 - Comet

These are the real life examples I am used to...

 

Spoiler
BronzeFox_0-1624233512121.png

 

dmceleney
7 - Meteor

solved

Ajjay
8 - Asteroid

Soln

EFos
8 - Asteroid
Spoiler
EFos_0-1625459315354.png

 

FredNajjar
9 - Comet
Spoiler
FredNajjar_0-1625571456675.png

 

j_trefethen
8 - Asteroid
Spoiler
challenge 28 JT solution.jpg

 Not as simple as the provided solution, but the output matches. Thanks to this community post for the nice Regex -  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Check-if-the-value-in-column-is-string...

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1626086827411.png

Struggled a fair bit with working out how to use the Multi-Row formula (i.e. moving parts in my head) to rearrange the ShareClass.

JackBurnham
8 - Asteroid

b

RashedDS
8 - Asteroid

My solution

 

Spoiler
RashedDS_0-1626390374663.png