Weekly Challenges for training

Hi All,

I'm looking for some weekly challenges for some training sessions I will be doing soon. I was wondering if anyone could recommend any challenges which requires Regex and Standard Macros.

The people I will be training will have only started Alteryx and I will be giving them a session on Regex and Macros prior, these will be for in class and homework.

Thank you

Data Challenge

Academy

Alteryx Practice

Accepted answers

All comments

Emil_Kos

Hi @DaisyJones,

Not sure if you are aware but there is a weekly challenge index that can allow you to search for beginner training in different areas.

https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

DaisyJones

Yes I am aware, but I wanted to find specific challenges with Regex and Macros. I find the filtering works, but some of the challenges are Iterative Macros or don't need Regex.

Thank you

kelly_gilbert

@DaisyJones - after parsing my own weekly challenge solutions, I didn't see any that I solved using regex AND a standard macro. Here are some challenges that used regex and an iterative or batch macro:

challenge	Macro Type	Macro	Regex Tool	Regex Function	Has Regex AND Macro
85	Batch	Yes		Yes	Yes
91	Batch	Yes	Yes		Yes
159	Batch	Yes	Yes		Yes
240	Iterative	Yes	Yes		Yes

I counted it as "using regex" if I used either a regex (parsing) tool or if I used a regex function in the Formula, Multi-Row Formula, etc. tools.

If you were looking to do a single challenge that covers both, you could consider taking an existing regex challenge and having users turn their solution into a macro. Some possibilities:

Challenge #4 - Date Parsing
Challenge #53 - Parsing Report Formatted Data - this actually uses a batch macro, since the input is on multiple rows, but you could use a text file input instead
Challenge #56 - Parsing and Counting Hashtags

I've attached the list of all challenges where I used either a macro and/or regex in my solution, so you can see some options for regex challenges. Just because I used a regex tool or formula in mine doesn't mean it's a regex-focused challenge, but at least that might narrow down the options for you!

Challenges that include macros or regex - KLG.csv

mceleavey

Hi @DaisyJones ,

In addition to what my esteemed cohorts have posted, I've attached the updated Weekly Challenge Index tool to help you keep track of what you've completed, among other things.