Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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 #11: Identify Logical Groups

meeravijayan2011
アステロイド
スポイラ
11.png
AryCardoso
アステロイド
 
jchua3
メテオール

solved by splitting up the find replace table and joining back again

LindaLo
アステロイド

quite like this challenge!

 

Simonvm9114
アステロイド

Fun and rather simple challange.

スポイラ
I forgot about the cleaning of the numbers though. Good point. I used the contains function to find the search in the complained, think that worked a bit easier than splitting every word.
sonyakasenkramer
アステロイド
スポイラ
sonyakasenkramer_0-1581108895055.png
Blake
クエーサー
スポイラ
Blake_0-1581448256276.png
mikeprice17
アステロイド

I think the directions were a little confusing. I was originally looking for the counts of those in each of the records, not just flagging if the record had the word. But figured it out. 

WegmanJordy
メテオール

Hereby the solution

dark_a
メテオール

Basically it is possible to do it using Find Replace tool, bet for some reason this tool is doing search in first 250 characters. I don't know why. So there is workaround.