We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A very cool and unexpected use of Alteryx. Most of it flowed smoothly, but I had a bear of a time dealing with the "." at the end of the sentence. Flew through the first bit, but fixing the space between the "." and "1" took waaaay more than 20 minutes
- Text to Columns (delimeter = " "_
- Find and Replace message to English
- Replace "/" with " " between words
- Remove commas
- Extract accident ID with RegEx tool
- Lookup accident field against accident ID
- Replace spaces between words with "/"
- RegEx tool to insert spaces between each character
- Change "1" to " 1"
- Insert Record ID (not needed, but not changing it now)
- Text to Columns Split to Rows with " " delimiter
- Convert to upper case
- Find and Replace tool to convert back to Morse code
- Convert Nulls to "/"
- Remove ","
- Remove extra "/"