String

Contents[Hide]

The String transform manipulates string columns in data tables by applying sting functions.

The following string functions are available:

  • Left
  • Remove
  • Replace
  • Right
  • Substring
  • ToLower
  • ToUpper
  • Trim
  • TrimEnd
  • TrimStart

String transform
String transform

Related video: Data Cleansing with Data Cubes

1. Input

The String transform requires 1 input transform that has at least 1 column.

The input could be a SQL Select transform, or the result of another transform. For example, we'll use the output of the Copy Column transform, as seen below:

Input Data: Department SQL table
Input Data: Department SQL table

2. Configure

Steps to configure the String transform:

  1. Select the column(s) you want to be included in the output.

    String transform configuration - Step 1
    String transform configuration - Step 1

  2. Click the Edit icon in line with the column name if you want to manipulate this string column.

    String transform configuration - Step 2
    String transform configuration - Step 2

  3. Select the String function from the DropDown list.

    String transform configuration - Step 3
    String transform configuration - Step 3

  4. At this stage, the result is:

    String transform configuration - String transform output
    String transform configuration - String transform output

  5. If you need to further manipulate the string column, you can add as many String transforms as needed.

    String transform configuration
    String transform configuration

  6. Select the String function from the DropDown list.

    String transform configuration
    String transform configuration

3. Output

The figure below illustrates the output of the 2 String transforms.

String - sample output
String - sample output

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri