Challenge #102: Tabulating Flu Data

[Natasha]

Renaming 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?

Spoiler

[derekbelyea]

Spoiler

[patrick_digan]

@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 :)

[ddiesel]

My Solution:

[SGolnik]

This was a quick one.

[Natasha]

@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 :)

[Ilías]

Better late than never!

[MichaelKaloz]

Completed,I thought the recommended solution was helpful in showcasing some of the developer tools i.e. "Dynamic Rename". I ended up using the "Select" tool to rename the headers and columns.

[CHarrison]

Nice & easy ;)

[Elena_Caric]

Solution attached