General Discussions

DaisyJones · ‎05-11-2021

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

Emil_Kos · ‎05-11-2021

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 · ‎05-11-2021

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

Emil_Kos · ‎05-11-2021

Hi,

I just took a look regarding the regex one:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-46-Formatting-a-Date-from-an-Integer/td-...

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-54-Data-Prep-Address-Parsing/td-p/44255

I hope this helps you at least a little bit.

TheOC · ‎05-12-2021

Hey @DaisyJones

May i also suggest these:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Iterative-Macr...
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Apps-and-Macros/ta-p/3...
Maybe as 'helper' documents to the homework being set?

Also, there are a couple of challenges that can utilise macros:
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-86-Create-a-Macro-that-Generates-Past-Da...
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-14-Warehouse-Distribution/td-p/36743

However, i may also suggest grabbing a dataset from Kaggle, and maybe seeing what different use-cases the students can come up with.

Hope this helps!
TheOC

kelly_gilbert · ‎05-16-2021

@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!

mceleavey · ‎05-25-2021

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.

M.