Challenge #53: Parsing Report Formatted Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SueDonim
8 - Asteroid
10-15-2019
05:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)

- 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)
RoDO
8 - Asteroid
10-17-2019
07:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
erick_irigoyen
Alteryx Alumni (Retired)
10-18-2019
10:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
justindavis
10 - Fireball
10-18-2019
09:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Interesting to see all the apps/macros based responses. Feel like this solution is dynamic and doesn't require either of those.
ArnavS
Alteryx Alumni (Retired)
10-28-2019
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Asal
7 - Meteor
10-28-2019
02:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
blundebjerg
8 - Asteroid
11-07-2019
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Rags1982
10 - Fireball
11-19-2019
07:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Benbryans
8 - Asteroid
11-19-2019
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Inactive User
Not applicable
11-21-2019
07:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator