community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Combining Fields in columns

Meteoroid

Capture.PNGCapture2.PNG

Looking to go from picture 1 to picture 2

Quasar

You could pass the first 2 columns (Select Tool) to one side of a Union Tool and the last 2 to the other. I can send an example later.

Quasar

Something like the following (see attached)

 

2018-12-11_16-07-29.png

Alteryx
Alteryx

As @ivoller points out, you could do this with a filter/select and Union, but the cool thing about Alteryx is that there is often multiple ways of getting to an answer.

 

I chose to go with a Formula tool that checks if one field is null and if it is, grabs the other one. Each method has its pro's and con's, see the example below.

 

Cheers!

Zak

Labels