Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAPretty 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.
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.