This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Check out the latest post: All Models Are Wrong
Looking to go from picture 1 to picture 2
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.
Something like the following (see attached)
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.