Adding a prefix to all values in a column

Arthi Annadi

Arthi Annadi Member

October 24 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

0

Best Answer

ColemenWilson Coach

October 24 edited October 24 Answer ✓
You can use the formula tile with the following formula:
CONCAT('Division',`Division`)
If I solved your problem, please select "yes" above
2

Answers

ColemenWilson Coach

October 24 edited October 24 Answer ✓
You can use the formula tile with the following formula:
CONCAT('Division',`Division`)
If I solved your problem, please select "yes" above
2
Arthi Annadi Member

October 24

@ColemenWilson Thanks

0

Categories