Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached.
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
Process:
- Text to Columns (delimeter = " "_
- Find and Replace message to English
- Replace "/" with " " between words
- Concatenate
- 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 "/"
- Concatenate
- Remove ","
- Remove extra "/"
My Effort