Adding columns to a dataset

Last updated: 10/16/2026

You can add columns to apply basic row-based transformations to a dataset.

You can add columns in Landing tasks that use Qlik Data Gateway - Data Movement, Storage, Transform, and Data mart tasks. You can also add columns in SaaS-managed landing, lake landing, replication, and Streaming Transform tasks. Expression elements depend on the task, source endpoint, and data platform.

1. Click Datasets.

2. Click Add column.

   You will need to provide a name for the column, and a data type.

   You can also set the column to be a key, and if it should be nullable.

   For some data types you can make additional settings, for example, length or precision.

3. Click the control on the column that you added.

   The expression builder is opened.

4. Build and test an expression to define the column values. See Building expressions.

5. When you are ready, click OK.

The column is now added, based on the expression you used.

Limitations

• It is not possible to use space characters in the column name when using Google BigQuery as data platform.