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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
New Data Science Blog

Check out the latest post: All Models Are Wrong

READ MORE
Announcement | We'll be doing maintenance between pm 4- 6pm MT, which may impact your experience. Thanks for your patience as we work on improving the community!

Combining Fields in columns

Highlighted
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