Hello,
I have 3 columns containing data type V_String, and I want to merge these 3 columns into 1. See below for an example of how I want to manipulate the data.
Before:
Column1 | Column2 | Column3 |
5632 | 14 | C |
6789 | 15 | D |
9078 | 14 | A |
After:
NewColumn |
563214C |
678915D |
907814A |
It looks like I should use the Formula tool, but I am not sure how. Any help would be greatly appreciated.
Thanks!
Solved! Go to Solution.
Hi draskay
The most straightforward approach here will be to add in a formula tool to create a new column, with the formula [Column1] + [Column2] + [Column3].
Thanks!