Adding a prefix to all values in a column

art_in_sky · 2024-10-24T14:57:10+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

ColemenWilson

You can use the formula tile with the following formula:

CONCAT('Division',`Division`)

All comments

ColemenWilson

You can use the formula tile with the following formula:

CONCAT('Division',`Division`)

art_in_sky

@ColemenWilson Thanks

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of