Challenge #53: Parsing Report Formatted Data

[grazitti_sapna]

[aplenos]

Spoiler

[acarter881]

Here's my solution.

Spoiler

[Thomas_Wells_2dot0]

Please find attached. I went with a macro that passes through the number of columns found in the starting data, and then updates a Text to Columns tool based on the total. 

Spoiler

 

[BenoitC]

Done! 

Spoiler

[BenoitC]

Didn't notice it had to be dynamic, changed a bit my workflow. I didn't have to use a batch macro

[_Viktoria_]

solution: i created a batch makro, but i had to create an input first, becuase alteryx wouldn't recognize the txt file...

[Pete_Rodgers]

Spoiler

call me lazy, but i can't see past this solution.  

Why not change the Delimeter to | and start data input to line 2, and you've 90% there...
Data cleanse takes out the rows of ----'s and a quick formula to standardise ClientID

note (confession): i may need to look into the definition of dynamic.

[Kinga]

Hi,

I've created dynamic solution without macro :)

Spoiler

[ahsanaali]

Spoiler