Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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

Highlighted
8 - Asteroid

My Effort - Text to Columns and an Iterative Macro

 

Spoiler
Flow
JamesCameron_0-1575460736959.png


Macro

JamesCameron_1-1575460806102.png
Highlighted
8 - Asteroid
Spoiler
Challenge 53 2019-12-16.jpg
Highlighted
Alteryx
Alteryx

The key to make my solution work was using one of the common techniques in Dynamic Workflows.

Text to Columns (Split to Rows)

Tile for Sequence Number

 

Spoiler
Challenge_53.png
Highlighted
8 - Asteroid

Only a little different for id=31211967, clienttimeprop is 1.83870967711935E instead of  1.83870967711935E-

Highlighted
8 - Asteroid
 
Highlighted
7 - Meteor

please find the attached solution file

Highlighted
Alteryx
Alteryx

Solution attached!

Highlighted
8 - Asteroid

Solved!

 

Spoiler
JonathanW_0-1578542820211.png
Highlighted
8 - Asteroid
Welcome to the Weekly Challenge. Each week Alteryx post a use case where you can put your Alteryx skills to the test. You'll be able to share your answers an...
Highlighted
8 - Asteroid

Thanks GeneR.