In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Conditionally "Union" 2 columns into 1

DataMarsh
6 - Meteoroid

Hi 

 

I am trying to combine 2 columns into on column but only if the value in another column is set to 'Yes'. I have figured out the Yes part, but I cannot get the data from column B (only the populated rows) to appear under the data from column A.

 

Any help would be appreciated. Thanks

 

I attached the file with sample data and in the second sheet the desired outcome. Any questions, please shout

5 REPLIES 5
FinnCharlton
13 - Pulsar

Hi @DataMarsh , here's how you can achieve this:

FinnCharlton_0-1686056699969.png

Hope it helps!

FrederikE
13 - Pulsar

Hey @DataMarsh,

 

FrederikE_0-1686056873718.png

 

Union Config. is on Position 

FrederikE_0-1686056919271.png

 

 

oneillp111
9 - Comet

oneillp111_0-1686056926504.png

Basically the same as @FinnCharlton 

binuacs
21 - Polaris

@DataMarsh One way of doing this

binuacs_0-1686056990610.png

 

DataMarsh
6 - Meteoroid

Thanks all! This helped! :) 

Labels
Top Solution Authors