Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
2 REPLIES 2
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

Labels