Alteryx designer Discussions

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

Merge three columns into one

Highlighted
Meteoroid

Hi there, 

 

I am trying to merge three columns of data into one. Right now my data looks like the below.. there are four columns under the same header "Type of requisition." I would like to merge all four columns into one column (see 2nd image). I'm not quite sure how I can do this with the transpose tool... Any help is MUCH appreciated!

BeforeBefore

AfterAfter

Highlighted
Quasar
Quasar

How about something like the attached?

Highlighted
Inactive User
Not applicable

This can easily be done using the formula tool. Create a new field called "Type of Requisition - Calculation" and set it to equal this:

 

=Trim([Type of Requisition - Column F]+[Type of Requisition - Column G]+[Type of Requisition - Column H]+[Type of Requisition - Column I])

 

After this, deselect the old 4 columns with a select tool and you are done.

Highlighted
Nebula
Nebula

Hey @koralynah - happy weekend.

 

I've mocked this up below - similar to the other posts on this.   If you use a multi-field formula tool to remove the '[Null]' from the blank fields, and a quick formula to pop the remaining bits together, you're off to the races!

 

2017-05-21_20-40-10.png2017-05-21_20-40-44.png

 

If this helps to solve the problem - would you mind marking this as solved, or if there are still questions feel free to reply and we can iterate with you.

 

Cheers

Sean

Alteryx Certified Partner
Alteryx Certified Partner

My approach would be slightly different but ends with exactly the same output. The attached workflow also is dynamic in case additional columns are added that should form part of the concatenation.

 

2017-05-22_12-59-21.png

2017-05-22_12-59-58.png

2017-05-22_13-00-13.png

Highlighted
Meteoroid

Thanks Ben Moss!!! It worked!

Labels