I have 2 columns that need to be combined as one, whats the best way to merge these 2 columns?
Solved! Go to Solution.
Hey @Hi2023, do you just simply want to combine them like this?
Or do you mean they're coming from 2 separate sources and you need to do a join of the two tables?
My solution will work even for huge datasets too.
If you want to remove the duplicates, then you can use unique tool to remove the duplicates.
Kindly accept this solution if it provided a solution to your question.
Many thanks
Shanker V
Depending on your exact requirements for combining, you can also use a Formula tool, to determine which column's value to use.
For example, assume you have data like this below and you want to combine Column1 and Column2:
RecordID | Column1 | Column2 |
1 | A | [Null] |
You could create a "New Column" with the following expression: IF IsNull(Column1) Then Column2 ELSE Column1 ENDIF
If you want to combined them under each other then union. If they have some unique ID in both and you want to combined them horizontally, then the join tool and joining by the unique value.