Prefix the Field Values - But not hard code - HOW?

[dmohanty]

Hi All,

I have a Field, let say Column A, where I have a 1000 of values available. Now I need here to prefix all the values with a common name, lets say - 'TEST_'

Example

Original Table	New Table
Column A	Column A
abc	TEST_abc
xyz	TEST_xyz
cba	TEST_cba
zyx	TEST_zyx

How can this be achieved?  Please suggest!

[marcus_sommer · Accepted solution]

Try:

New:

Load 'TEST_' & [Column A] as [New Column A] Resident OriginalTable;

- Marcus

[dmohanty]

Thanks very much Marcus. That helped!