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

Challenge #366: Three Columns Are a Crowd

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here MergeSign.jpeg

 

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: 

 

AYXAcademy_0-1681135509766.png

 

 

 

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: 

 

AYXAcademy_1-1681135509767.png

 

 

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_1-1681136248874.png

 


 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1681136249062.png

 

ahsanaali
11 - Bolide

Congratulations @AkimasaKajitani ! You won by 23 seconds 😀

binuacs
20 - Arcturus
Spoiler
binuacs_0-1681136568826.png

 

bkclaw113
9 - Comet

Nice easy

Spoiler
bkclaw113_0-1681136620418.png

 

AkimasaKajitani
17 - Castor
17 - Castor

Thank you! @ahsanaali 

 

 

By the way, this is Designer Experience version.

Spoiler
AkimasaKajitani_0-1681136585002.png

 

AkimasaKajitani_1-1681136621346.png

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Text output didn't have spaces after commas and probably should, but configured workflow to match output given

Kenda_0-1681136764671.png

 

braveraj
11 - Bolide
Spoiler
braveraj_0-1681136799326.png braveraj_1-1681136817322.png

 

 

 

gaoa
11 - Bolide
Spoiler
gaoa_1-1681136967192.png