How can I merge two columns in to 1?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do I tell it where to put the combined columns? Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
