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