Cloud Quest #8: Settle the Score

[JoachimCaronTIL]

Here is my solution

 

[ScottMcV]

I saw the missing case sensitivity someone referenced elsewhere that would have made it easier and ran into it myself.

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

I hope that the RegEX_Match function has the case intensive option similar to the Designer Desktop.

[Shelbey]

Spoiler

[Towers]

really like regex 

Spoiler

 

[RobertW]

Spoiler

[mceleavey]

Nice and easy. Come on, Alteryx gods, challenge me. Really go to town on me.

Spoiler

I tokenised the Score string to rows using any character, then regex matched the uppercase characters. I then assigned points to the matched/un-matched records then set all to lower case. Then I simply cross-tabbed back creating a sum by each character and created the total field.

[OllieClarke]

I thought that would be more straightfoward

Spoiler

Who knew = was case insensitive :(

[OllieClarke]

@mceleavey I know my attempt is way more convoluted than yours, but you can drop a tool by creating the total column in the cross-tab as well :)

[mceleavey]

You are correct, sir!