Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEARenaming columns was the most interesting part, I used simple replace without regex.
@patrick_digan I had a look at your 2 tool solution, how did you manage to sum a text field in the summarise tool?
@Natasha You can use a select tool to convert it to double, setup your summarize, and then "delete and connect around" the select tool and it will still work! You can also edit the xml of the summarize tool. I'd never use it in a real workflow :)
@patrick_digan thanks for clarifying! I tried these and both work. I feel that "delete and connect around" is a bit of a cheating but I like xml edit hack :)