ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

JamesCameron
アステロイド

My Effort - Text to Columns and an Iterative Macro

 

スポイラ
Flow
JamesCameron_0-1575460736959.png


Macro

JamesCameron_1-1575460806102.png
danicahui
アステロイド
スポイラ
Challenge 53 2019-12-16.jpg
KaneG
Alteryx Alumni (Retired)

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

 

スポイラ
Challenge_53.png
nini
アステロイド

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

rmassambane
ボリード
 
Ivyin702
メテオール

please find the attached solution file

wdavis
Alteryx Alumni (Retired)

Solution attached!

JonathanW
アステロイド

Solved!

 

スポイラ
JonathanW_0-1578542820211.png
Nicholas_Bignell
アステロイド
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 and collaborate with other challengers to arrive at an answer. Participation will be rewarded - just make sure you are attaching your Alteryx ...
dashakir1
アステロイド

Thanks GeneR.