Cloud Quest #8: Settle the Score

[bradshaw]

That took a bit longer than it should have.

Spoiler

[phottovy]

Another quest complete!

Spoiler

[mshishido]

here

[ggruccio]

Fun with Regex!  Others might have found a more efficient way to do this!

Spoiler

[logdog0411]

Spoiler

 

[thomasduong]

Here is my solution to CQ8

[patrick_digan]

Spoiler

[SGolnik]

Spoiler

 Fun one!

[smurfitt]

Initially I thought a manual table as there were only 5 players would make life easier to group and add the scores, but I also added a 2nd option which did not need the manual table entries.   Attached in my solution with the 2 different approaches.

[Carolyn]

Solved!

What was very interesting in a "I don't like this and this isn't how Desktop works" way - 

Spoiler

I set my If/Then to identify if a field was upper or lower case in formula expression #1. Then in formula expression #2, I turned all the Scores to lowercase so they would Summarize properly in my next tool. What I found was that formula expression #1 re-evaluated based on the results of #2, even though #2 came after #1



I got around it by just creating a brand new column called Player, but I wasn't expecting that to happen, since that's not how Desktop behaves



FYI @AYXAcademy - Not sure if this is a bug or how Designer Cloud is expected to behave. Let me know if I should make a Support ticket

Solution: 

Spoiler