In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1656349668400.png

 

Opened this one for some macro practise but this doesn't really seem to need it? Certainly feels like a pretty robustly dynamic solution.

jonathanwillis
8 - Asteroid

Here's my solution

AnnaLawrence
Alteryx
Alteryx
Spoiler
AnnaELawrence_0-1657892152073.png

 

Albert_Vega
8 - Asteroid

I honestly needed some help on this one. Macros are my strong point.... yet! 🤔

DataGuru87
Alteryx
Alteryx

Here is my solution to the weekly challenge!

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_0-1659106748562.png

 

martinding
13 - Pulsar

😀

dkungu
8 - Asteroid

Created a macro that parses the column names and the table data. Though not dynamic on the delimiter.

Spoiler
Pic- challenge_53_Diana_Kungu.png
Brian32
8 - Asteroid

Challenge Solution:

Spoiler
Brian32_0-1660595499298.png

Not a macro solution, but is dynamic.

Abiramm1
8 - Asteroid

Completed this one with a standard macro and a multi row formula :)

Spoiler
Abiramm1_0-1660903307999.png