Challenge #366: Three Columns Are a Crowd
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A solution to last week's challenge can be found here.
To solve this week’s challenge, use Designer Desktop or Designer Cloud, Trifacta Classic.
Merging columns is straightforward with Alteryx. However, in some scenarios there is more complexity to the merge than a simple transformation. In this Weekly Challenge, you have collected address information for your customers, but the information is not always complete. In the input file, you have multiple columns of data for an address: Address, Apt/Unit, and Zip. You need to merge the columns, but some of the column data is blank. For example:
This week your goal is to create a workflow that merges the Address, Apt/Unit, and Zip columns, and ignores any blank values.
Your output should look like this:
- Labels:
- Core
- Data Preparation
- Intermediate
- Transform
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Congratulations @AkimasaKajitani ! You won by 23 seconds 😀
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice easy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator