Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #53: Parsing Report Formatted Data

SueDonim
8 - Asteroid

Spent more time cleaning up the data than parsing it, but that also uncovered some errors in my process (like removing punctuation resulting in decimals I wanted being deleted) - diligence matters....

 

I guess mine isn't dynamic regarding number of columns....

 

Spoiler
Process:
- Test to columns, with "|" delimiter
- Removed Null records (that got rid of the row separator "------------etc"
- Data Cleansing to remove trailing spaces, etc
- Dynamic Rename to capture field names in Record 1
- Clean-up getting rid of N/As, a couple of extraneous |, and empty fields (convert to Null)

MySolution.PNG

 

 

 

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_53_RODO_Solution.png
erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

justindavis
9 - Comet

Interesting to see all the apps/macros based responses. Feel like this solution is dynamic and doesn't require either of those.

Spoiler
challenge_53_solution_justindavis.PNG
ArnavS
Alteryx
Alteryx
 
Asal
7 - Meteor

This is my solution!

blundebjerg
8 - Asteroid
 
Rags1982
8 - Asteroid
 
Benbryans
8 - Asteroid
 
lreid014
8 - Asteroid