Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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:
