community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #130: Is There an Echo in Here?

Meteor
Spoiler
REGEX_Replace([Phrase],"(\b\w+\b)\W+\1","$1")

challenge_130_Solution_Shokat.PNG
Asteroid

I tried recreating this, this way but after my concat on the summarize tool, it adds commas between each word.  Yours doesn't do this, do you know why?

 

 

Asteroid

Here is my solution... 

Alteryx Partner
Spoiler
Challenge130.PNG

My solution

Asteroid
Spoiler
Spoiler 

Picture2.png
Asteroid
 
Asteroid

Nice to make use of multi row formula

Asteroid

not a one tool way, regex is powerful but not good at it though, need to learn more

 

Spoiler
Spoiler
12.PNG
Asteroid

Challenge Completed

Asteroid

My solution, never came across Regex before using Alteryx and it's proving to be so useful!