> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# MultiColumnEdit

> Change the data type of multiple columns at once

export const gemName_0 = "MultiColumnEdit"

export const execution_engine_0 = "the SQL warehouse"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

The MultiColumnEdit gem primarily lets you cast or change the data type of multiple columns at once. It provides additional functionality, including:

* Adding a prefix or suffix to selected columns.
* Applying a custom expression to selected columns.

<Tip>
  The {gemName_0} gem has a corresponding interactive gem example. See [Interactive gem
  examples](/data-analysis/gems/gems#interactive-gem-examples) to learn how to run sample pipelines
  for this and other gems.
</Tip>

## Prerequisites

* Add `prophecy_basics` package version 1.0.0 or higher to your project.

## Parameters

| Parameter                                                             | Description                                                                                                                                         | Required |
| --------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------- | -------- |
| Selected columns to edit                                              | Choose which columns you want to transform.                                                                                                         | Yes      |
| Maintain the original columns and add prefix/suffix to the new column | If checked, the original columns will stay the same and new ones will be added with the prefix/suffix. Otherwise, the original column names change. | No       |
| Prefix/Suffix dropdown                                                | Lets you choose whether to add text at the beginning (prefix) or end (suffix) of the column names.                                                  | No       |
| Build a single expression to apply to all selected columns            | A SQL expression you apply to each selected column. If you don't want to change the values, enter `column_value`.                                   | Yes      |