Alteryx Designer Desktop Discussions

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

Merge two Columns

neromerob
10 - Fireball

Hello. 

 

I have a workflow that produce 2 different outputs. 

 

files.jpg

 

I´m looking for a way to unite the information like this. 

 

Final_result.jpg

 

So any Idea on how to produce an Output Like that is welcome. 

 

Thank You. 

2 REPLIES 2
TheCoffeeDude
11 - Bolide

The join tool is what you're looking for. Notice the configuration - I un-ticked the month from the right input.

TheCoffeeDude_0-1654320593103.png


The result:

TheCoffeeDude_1-1654320624958.png

 

binuacs
20 - Arcturus

@neromerob Another way of doing this with the Find and Replace tool

binuacs_0-1654335351925.png

 

Labels