Weekly Challenges

mtouiti · ‎03-14-2019

like that frequency tool, well done

Verakso · ‎03-14-2019

What a fun and great challenge

But my first take I failed miserably 😂

Spoiler

kck Who's tnhere? Irisoh! Irish Wcho? Irish kyou a happ y St. PatrKick's Day!no

In the end, my solution ended up looking exact as @nerces so big kudos there 👍

Spoiler

Apparently not many have facilitated the »Data Investigation« tools in Alteryx, but they are some really cleaver tools if you would like to dig deeper in the data itself

The split of the data using RegEx tool and then again using the Summarize tool is not that difficult, I had just not taken into consideration that the order of the letters was determined by the actual frequency, which had me returning that piece of rubbish above.

Of course the correct result is:

knock Knock Who's there? Irish! Irish Who? Irish you a happy St. Patrick's Day!

Apparently not many have facilitated the »Data Investigation« tools in Alteryx, but they are some really cleaver tools if you would like to dig deeper in the data itselfThe split of the data using RegEx tool and then again using the Summarize tool is not that difficult, I had just not taken into consideration that the order of the letters was determined by the actual frequency, which had me returning that piece of rubbish above.Of course the correct result is:knock Knock Who's there? Irish! Irish Who? Irish you a happy St. Patrick's Day!