Challenge #28: Formatting Financial Data

[jasperlch]

Solution attached.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[dsmdavid]

Similar approach to others, keeping separated steps to obtain date, labels and values

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[msicak]

my solution below.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jamielaird]

Here's my solution. I changed the numeric field types to Double in the final tool as that seemed tidier.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[blairmbailey]

Solution attached - thanks!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JosephSerpis]

Challenge Completed

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[justin_winter]

Terribly inefficient, but still works!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[kelly_gilbert]

Catching up on some older challenges...  This was great practice on cleaning/reformatting an input file!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[CHarrison]

My solution 😄

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[luciebrett]

The only difference between my version and the solution is that i used an extra select tool rather than removing the additional columns in the append fields tool - good to know!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.