Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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:
Just out of curiosity, why is this listed as Intermediate level? I would think this is a Beginner challenge.
