Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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
10 - Fireball

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
10 - Fireball
 
Benbryans
8 - Asteroid
 
Inactive User
Not applicable