How can I merge two columns in to 1?

[yashwanth522]

Hello 

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

Team	Team_Live
Team1	Null
Team2	Team2
Team3	Null
Team4	Team2
Team5	Team3

[ivoller · Accepted solution]

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 · Accepted solution]

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]

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

[AndrewDMerrill]

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: