Copy Element

Contents[Hide]

The Copy Element transform creates new columns by copying selected input columns and adding the new columns to the output.

This can be used in cases where you need to manipulate a column but want to keep the original column as well.

Transform - Copy Element
Transform - Copy Element

1. Input

The Copy Element transform requires 1 input transform that has at least 1 column.

For example, the input could be a SQL Select transform, or the result of another transform. For example, we'll use AdventureWorks' Department table:

Input Data: Department table
Input Data: Department table

2. Configure

Steps to configure the Copy Element transform:

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

    Copy Element configuration - Step 1
    Copy Element configuration - Step 1

  2. Click on the Copy icon to copy the column. You can repeat this for every column you want to copy.

    Copy Element configuration - Step 2
    Copy Element configuration - Step 2

  3. Optional, under the CopiedColumns section:
    • Click the Edit icon to rename the column.
    • Click the Delete icon to remove the column.

3. Output

The figure below illustrates the output from the Copy Element transform.

Copy Element output example
Copy Element output example

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