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

AnnaELawrence
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! 🤔

MelvinA
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