Skip to main content

Combine Columns

This task can be used to combine one or more values. The values can be applied selectively.

Quickstart

Let us start with the following data.

DayMonthYear
10April2010
12March2010

Our goal is construct a Date column that combines values from the first three columns like this.

DayMonthYearDate
10April201010 April, 2010
12March201012 March, 2010

In the Date column, note the space between day & month and comma followed by space after the month name. Combine column allows interleaving character strings to achieve this. The interleaving of column and characters has to be done in the order it is to appear in the result string. To achieve above results, we should add following in order

  1. Day Column
  2. Space
  3. Month Column
  4. A string ", "
  5. Year Column

To achieve this

  1. Go to Transform > Column Functions.
  2. Select the Combine Multiple Columns function.
  3. Choose a combination of columns and String value by clicking on + button in the order you would like them to appear.
  4. Enter the name of the new column into which you would like the results to appear. For the current example enter text Date in the Apply Result Into section.
  5. Click APPLY. The view would update with the new column called Date.

Supported Options

  • Result: A combination of column names and interleaved strings that the resultant column should have
  • Condition: See Condition.
  • Apply result into: This option allows configuration of the destination of the results by this task. See result documentation.