Search

Close

Start Free Trial

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

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.

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

solved

Soln

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...

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.

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.

b

My solution

Live Weekly Challenge