You can merge two column or column and a value and create a new column out of it. The steps to follow are -
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.
Step 2: On preview screen, select any column which you want to merge and click on down arrow.
Step 3: You can choose "merge column/new column" by clicking on required option from Others section. It will open up a pop up window for new column.
Step 4: You can either choose to merge the column you selected with some text value or with some other column Fill the required details as listed below and click "Save Changes"
- First box: it contains the column name which you selected
- Operator : you can select the operation like add,subtract,multiply or divide from the dropdown
- Text or column radio button : select the one option which you want . If you want to apply the operation with some text value select text or else if you want some other column select column
- Depending on the radio button either fill the text or numeric value which you want to add,subtract, multiply or divide or select the column name from dropdown.
Step 5: Once you click on save changes, the system will apply the merge operation on column considering the option selected and column will be merged in to new column accordingly.