Adding a prefix to all values in a column

art_in_sky
art_in_sky Contributor
in Magic ETL

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

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited October 2024 Answer ✓

    You can use the formula tile with the following formula: 

    CONCAT('Division',`Division`)

    Screenshot 2024-10-24 at 9.42.51 AM.png

    If I solved your problem, please select "yes" above

Answers

Categories