Challenge #489: From Chaos to Clarity

[dsong713]

Spoiler

[Erin]

Spoiler

[alexnajm]

Done!

Spoiler

[abacon]

Really fun challenge!!

Spoiler

Task 1Task 2

[joeyfel]

Spoiler

Here's my solution!

[Yoshiro_Fujimori]

I had Input Data Tool do all the parsing work 😀.

(https://help.alteryx.com/current/en/designer/file-types-support/flat--ascii--files.html)

Spoiler

Workflow

.flat file

<flatfile version="1">
<file
path="Input.txt"
eoltype="crlf"
trimWhiteSpace="t"
allowShortLines="t"
/>
<fields>
<field name="Account No." type="String" length="10" />
<field name="Name" type="String" length="16" />
<field name="Fake Identity" type="String" length="11" />
<field name="Date" type="Date" length="10" />
<field name="Action" type="String" length="14" />
<field name="Amount" type="Double" length="7" />
</fields>
</flatfile>​

Graph

[NatSnook]

Thanks all

Spoiler

[balajilolla3]

Spoiler

Solution Attached

[Carlithian]

hmmm looking at the other answers I probably should have used a dynamic rename, but opted to not bother :P

Spoiler

[Qiu]

@caltang  Nice one. Congratulations.

Spoiler