Adding a prefix to all values in a column

Arthi Annadi

I have a column named Division with integers ( numbers), I want to add a prefix 'Division' to to all values in the column to align it with all the values in the appended columns. What tile in Magic ETL would let me do this?

I converted my integer column to text using 'Alter Columns' and now am waiting to replace the values using a prefix

ColemenWilson

You can use the formula tile with the following formula:

CONCAT('Division',`Division`) 

ColemenWilson

You can use the formula tile with the following formula:

CONCAT('Division',`Division`) 

Arthi Annadi

@ColemenWilson Thanks