Adding Columns to a Dataset

You can develop your datasets by adding columns. For example, you might create a new column that concatenates columns ADDRESS_LINE_1, ADDRESS_LINE_2, and ADDRESS_LINE_3.

  1. On the Home page, select the dataset, click the Actions menu, and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
  2. In the transform editor, click Add Preparation Step.
  3. In Create Column, enter a Name for the column, and in the expression box define an expression to add values to the column. For example, to concatenate values in columns Category and Sub-category, you might specify: CONCAT(Category, Sub Category).
  4. Use the f(x) function picker to build an expression using operators, mathematical, string, and conversion functions.
  5. Click Validate and review the new column in the data preview.
  6. Click Add Step.

    CIC Analytics adds a step to the Preparation Script panel.

  7. To save your data preparation changes and apply them to your data, click Save Dataset.

    If you're working with a single table dataset or a file-based dataset, click Apply Script.

Related Topics

Preparing your Data Set for Analysis

About Data Enrichment and Transformation in CIC Analytics

Enriching and Transforming Your Data

Accepting Enrichment Recommendations

Transforming Data Using Column Menu Options

Transforming Data Using Replace

Converting Text Columns to Date or Time Columns

Adjusting the Display Format of a Date or Number Column

Creating a Bin Column When You Prepare Data

Configuring Column Properties in a Dataset

Hiding or Deleting a Column

Restoring a Hidden or Deleted Column

Editing the Data Preparation Script

Creating Calculated Data Elements in a Workbook



Last Published Friday, December 8, 2023