What a fun and great challenge
But my first take I failed miserably 😂
In the end, my solution ended up looking exact as @nerces so big kudos there 👍
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!