Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATried to parse out headers on the first go around. Gave up and just parsed the data and added the headers.
I went way too far before noticing that the headers included in the report in no way resemble those in the output! Anyway, here is my successful mess.
Love a bit of regex!
Always love a parsing challenge! I used some nice tricks in here.
Process:
1) view data row-wise
2) parse data with some tricks
3) attach inception date back to parsed data
4) aggregate data
5) grab headers from answer using dynamic rename
really fun!