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

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

I used a dynamic tool to be as dynamic as possible.

But at column "clientid" and "clienttimeprop" , there are not dynamically to cleaning.

It is important to divide the fields at splitting to row.

 

 

Spoiler

AkimasaKajitani_0-1600091425597.png

 

 

 

LukaszKarpinski
8 - Asteroid

Hi,

 

My solution attached. I know nothing about macros yet, so I tried tackling this using basic tools. Current setup allows for the 20 extra columns to be processed (if they appear) and this number can be increased if needed.

 

Spoiler
Łukasz_0-1600158311644.png

 

Qiu
21 - Polaris
21 - Polaris

Not so difficult

Spoiler
en-53.PNG
JoePC
9 - Comet

Solution Attached

anshuverma0912
8 - Asteroid

Hi, here is my solution!! I am happy, I was able to solve this one really fast..

greggrimmer1
8 - Asteroid
Spoiler
greggrimmer_0-1603984428454.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-30 à 09.53.25.png
WernerE
8 - Asteroid

Thanks

Sashikumar
8 - Asteroid

Good

Spoiler
ch53.PNG
Normster
8 - Asteroid

This one was pretty straightforward so I didn't see a need to use a macro.  

 

 

Spoiler
Normster_0-1607453248983.png