---
title: "columnRearrange"
description: "Returns a view of the given dataset with the given columns in the order specified."
---

# columnRearrange

> Returns a view of the given dataset with the given columns in the order specified.

**This function is used by Ignition's Expression language.**

## Description
Returns a view of the given dataset with the given columns in the order specified. Columns may be omitted in order to filter out columns from the original dataset.

## Syntax
` columnRearrange(dataset[, col...])`

- Parameters

    - DataSet **dataset** - The starting dataset.

    - string **col** - Optional. Any number of column names, in the order that they should appear. The columns specified must match columns in the original dataset.

- Results
    - DataSet - A new dataset with columns in the order specified.

## Examples
```python title="Code Snippet"
columnRearrange(fiveColDataset, "secondCol", "thirdCol", "firstCol") // returns a 3 column Dataset, where the columns are in the given order.
```