Merge columns
Checks for text in the columns specified in sequence, returns the first set of text it finds, replacing the original columns.
Checks for text in the columns specified in sequence, and returns the first set of text it finds, replacing the original columns.
When to use this tool
Use when you have inconsistent text columns and want to combine them into a single column.
Input
The Merge columns tool requires one data input.
Configuration
Use the following configuration options to help create your Merge columns configuration.
In , add your data source.
Click +Add Tool.
Click See all tools.
In the search bar, search for Merge columns. Click Add tool.
Tip
You can also find the Merge columns tool in the Calculate section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 44. Merge column tool configurationField
Description
Column
Select the column or columns that you want to use to merge.
New column name
Enter the new column name.