Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How can I merge two columns in to 1?

yashwanth522
7 - Meteor

Hello 

 

I'm trying to merge two columns with data into one column.  My data is something similar to the following,

 

TeamTeam_Live
Team1Null
Team2Team2
Team3Null
Team4Team2
Team5Team3
4 REPLIES 4
ivoller
12 - Quasar

Hi,

 

You can use a formula tool with an appropriate expression to join the data and then a select to choose which fields to output.

 

In your example data, what is the expected output?

 

If it's just concatenated data then a formula like this would work

 

    [Team]+[Team_Live]

 

Make sure the output datatype length is big enough to accommodate the new data.

 

Cheers,

Iain

 

 

 

 

yashwanth522
7 - Meteor

Hello Lain

 

Thanks for your quick reply. It worked out great although I'm not trying to concatenate, the idea of utilizing formula tool worked absolutely fine. I have used the following condition in the Formula tool to generate a new column which resolved my business need,

 

IF ISNULL([Team_Live]) THEN [Team] ELSE [Team_Live] ENDIF

 

I was trying to replace null values of one column with other.

 

Cheers

Yashwanth

elenareiss
6 - Meteoroid

How do I tell it where to put the combined columns? Thanks.

AndrewDMerrill
13 - Pulsar

This may be a far simpler answer than you are seeking, but if you are using the Formula Tool, then you'd just choose the column from the drop-down. If this is not what you're looking for, please provide more specific information:

Alteryx Formula Tool Choose Column.png

Labels