> ## Documentation Index > Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Old Magic ETL Tiles: Edit Columns export const InlineImage = ({src, alt = '', height = '1.6em'}) => { return {alt}; }; ## Intro **Note:** This article is for the old Magic ETL. For information on the new Magic ETL, see [Magic ETL](/s/topic/0TO5w000000ZanvGAC). This article describes in detail most of the **Edit Columns** tiles in Magic ETL, including the following: * Add Constants * Calculator * Collapse Columns * Combine Columns * Date Operations * Group By * Select Columns * Set Column Type * Split Column * Uncollapse Columns This topic does not discuss the Rank & Window tiles. For information about these tiles, see [Magic ETL Tiles: Rank and Window](/s/article/360042922814 "ETL Actions: Rank and Window"). For information about creating a Magic ETL DataFlow, see Creating a Magic ETL DataFlow. For information about the Data Center, see [Data Center Layout](https://domo-support.domo.com/s/article/360047553253?language=en_US). ## Add Constants The Add Constants tile lets you add a column with constant values. **To configure the Add Constants tile,** 1. Click the **Add Constants** tile in the canvas. 2. (Optional) Rename the tile by clicking , then entering the name you want. 3. Enter the name of the new column. 4. Select the column type.

Column Type

Description

Text

Contains text and numbers (which are treated as text).

Decimal

Contains numbers in decimal notation.

Decimal (Fixed)

Contains decimal numbers with a fixed number of digits after the decimal point.

Whole Number

Contains numbers without a decimal part.

Date

Contains date values.

Date and Time

Contains date and time values.

5. Enter the constant value, date, date and time, or leave it blank. **Tip:** You can preview the data transformed by a tile by running a preview, clicking the tile in the canvas, then clicking the **Preview** tab. ## Calculator The Calculator tile lets you add a column with values from a simple calculation. **To configure the Calculator tile,** 1. Click the **Calculator** tile in the canvas. 2. (Optional) Rename the tile by clicking , then entering the name you want. 3. Enter the name of the new column. 4. Select the operation you want.

Operation

Description

Addition

Adds values from two columns.

Subtrtile

Subtracts values from two columns.

Multiplication

Multiplies values from two columns.

Division

Divides values from two columns.

Ceiling

Returns the highest value for each series in a numeric column.

Floor

Returns the lowest value for each series in a numeric column.

5. Select the columns to use or specify the values you want. **Tip:** You can preview the data transformed by a tile by running a preview, clicking the tile in the canvas, then clicking the **Preview** tab. ## Collapse Columns The Collapse Columns tile lets you "unpivot" or "normalize" data in tables, transforming multiple columns in a single row into a single column with multiple rows. This tile is useful only for unpivoting data in which the number of columns stays the same. If you add another column of data to the original file, this tile does not collapse or unpivot the new column. **Example** For example, the Collapse Columns tile converts data in this pivoted format... etl_rownormalizer_datain.png ... to data in this format... etl_rownormalizer_dataout.png ... using this configuration: etl_rownormalizer_sampleui.png **To configure the Collapse Columns tile,** 1. Click the **Collapse Columns** tile in the canvas. 2. (Optional) Rename the tile by clicking the edit icon, then entering the name you want. 3. Enter the name of the column you want to create to contain the column headings from the columns to collapse. For example, "Product". 4. Enter the name of the column you want to create to contain the row values from the columns to be collapsed. For example, "Sales". 5. For each column you want to collapse, do the following: 1. Select a column to normalize. For example, "Product A". 2. Enter a value representing the column header to be normalized. The value appears in the row of the new column. For example, "A". 3. (Conditional) If you want to collapse another column, then click **Add Column**. **Tip:** You can preview the data transformed by a tile by running a preview, clicking the tile in the canvas, then clicking the **Preview** tab. ## Combine Columns The Combine Columns tile lets you combine values from multiple columns into one column. For example, you could combine first name and last name from two columns into a new, full name column. **Video - Combining Columns in Magic ETL**