Challenge #119: Inspire Weekly Challenge
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
adampowers
5 - Atom
06-08-2018
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
NicoleJohnson
ACE Emeritus
06-08-2018
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Quick comment to give @ credit to two of the “Team Awesome” Weekly Challenge members who are now new members of the Alteryx Community... welcome, @smclerran & @Bradg!! It was so great having you two on our team, and I’m looking forward to seeing the cool things you continue to discover while exploring this incredible Community resource! See you at the next Inspire!!
Cheers, NJ
Cheers, NJ
patrick_digan
17 - Castor
06-08-2018
09:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As I looked through other answers and talked to @DultonM about something unrelated to this challenge, I realized that I completely over complicated my solution in my rush to get it done.
Spoiler
I use the Find Replace tool all the time, but I'm usually just using it to append data. I completely didn't realize that you could replace multiple items when using it for replacing. That little fun fact makes my solution much simpler:
arein0
8 - Asteroid
06-08-2018
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
06-08-2018
01:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataRangler, sorry for the delayed response. We are all flying home from our conference today. Good catch - I mistakenly uploaded the wrong file in the heat of our live session. It's been updated to have the latest version.
SeanAdams
17 - Castor
06-08-2018
02:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
:-) nice way to spend the time in the airport, waiting for the outbound flight.
Super over-complicated compared to some of the solutions posted above
Spoiler
Did this in the 3 phases posted in the problem. After looking at the other solutions I could have done this MUCH easier by using the power of the replace tool; and the ability for Text to Columns to ignore blank results.
Phase 1:
Phase 2:
Phase 3:
Phase 1:
Phase 2:
Phase 3:
trodriguez91
6 - Meteoroid
06-08-2018
02:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was kind of cool to take a reference from the web and then utilize it when decoding data.
trodriguez91
6 - Meteoroid
06-08-2018
03:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
estherb47
15 - Aurora
06-08-2018
03:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
TylerNa
10 - Fireball
06-08-2018
04:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator