Magic ETL

Magic ETL

Adding a prefix to all values in a column

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

  • edited October 2024 Answer ✓

    You can use the formula tile with the following formula:

    1. CONCAT('Division',`Division`)

    Screenshot 2024-10-24 at 9.42.51 AM.png

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

Answers

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In