How to split a column in to two?
To split string values in a column you can use the split operation. This operator will create two new columns containing the two split values based on the operation you perform. You can perform this operation in two ways:
Using suggestions on Right panel
Step 1: When you create a new connection,you will get to Preview Screen.
Step 2: On preview screen, select the column in which you want to split something. As and when you highlight some values within the column, you can get a list of suggested split which is possible on that column in suggestions tab of right panel.
Step 3 : Right Suggestion panel will give you options to split on, from or between particular position, characters, separator etc. When you hover on these options, You will get a preview of the possible output adjacent to the column in light yellow color.
Step 4: You can select the one which you like and click on it. It will apply the selected split operation on the column and will split the column in to two name "split" for the result . You can rename the column as desired.
Using drop down from Transformation section
Step 1: When you create a new connection, you will get to Preview Screen.
Step 2: On preview screen, select the column in which you want to split and click on down arrow.
Step 3: You can either choose : "Split value by position" or "Split value by separator" by clicking on required option from String operations section. It will open up a pop up window for split.
Step 4: Fill the required details as listed below and click "Apply"
split by separator: The separator with which you want to split the column (if you select split by separator in drop down list)
split by position : The position number from which you want to split the column in to two (if you select split by position from the drop down list)
Step 5: Once you click on Apply, the system will apply the split operation on column considering the position or separator selected and column will be split in to two new column accordingly.