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 #22: Identify Values to Aggregate

Normster
Asteroide

I took a slightly different approach and came to the same conclusion.  (Instead of parsing to rows I parsed to columns and then transposed to finish the workflow). 

 

Normster

PeterH23
Asteroide

My solution

Saqueador
Challenge#22.png
myouree
Asteroide

Solution attached.

kaianderson
Asteroide

Here's my solution!

aheikes
Asteroide
Saqueador
Challenge22.JPG
atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Saqueador
This is my solution

atcodedog05_0-1585284383609.png

 

Ivyin702
Meteoro
Saqueador
Ivyin702_0-1585612639661.png

 

Regex is a wonderful tool. I use Token to parse all the amount and sum them together only using 4 tools. Make my life much easier 

grossal
15 - Aurora
15 - Aurora

Time to work on these challenges!

 

Saqueador
grossal_0-1586517966149.png

 

No-brainer to me! Regex for the win!

steven4320555
Asteroide

The vantage Alteryx icon is so colorful. Looks like screen shot for the purpose of the tools. Text input, browse and record ID are very visual.

 

Good practice for Regex, still a lot of try and error to get there. But I am less frustrated, and I was happy to saw my regex expression worked, especially the first tokenize one.

Saqueador

For the second parse regex, I had to adjust my initial Regex expression to accommodate the special case. And I worked. 

steven4320555_0-1586718543686.png

 

 

steven4320555_1-1586718994638.png

steven4320555_2-1586719013093.png

 

 

Inactive User
Não aplicável

PFA the solution.