Search

Close

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

I got so many Alteryx challenges to do after seeing the data I didn't even attempt to do it the hard way. I don't need to suffer!

Challenge 142 screenshot.png

Method 1 used manual rate entry into the Tile tool - boo. Method 2 used the append tool to add rates to compare income values - better!

Method 1 used manual rate entry into the Tile tool - boo. Method 2 used the append tool to add rates to compare income values - better!

Done!

Screenshot 2023-07-08 101741.png

Read up about Dynamic Replace and my golly, it's a great tool!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/

Learnings

1. function: REGEX_Replace(). Using the pipe operator to specify 'or' logic

2. regex: '$2'backreference second capture

I did it the hard( for me easy way) using the good ole swiss army knife or Regex. I also did it using the forbidden tools. Whats next - a tool budget?

I did it the hard( for me easy way) using the good ole swiss army knife or Regex. I also did it using the forbidden tools. Whats next - a tool budget?

My Solution

my solution

Oof, I missed the Transpose and Cross tab tools! I struggled with the iterative macro but finally got it to work - I clearly need to practice more on that!

Done