Any way to replace one value with another value in entire data model irrespective of columns?

[chiru_thota]

Hi All,

Is there a way to replace one value with another value in entire data model irrespective of columns?

for example if I have one value as USA and I want to replace it with AMERICA in all columns ( Ex:100 columns) .

Any ideas ?

Thanks,

Chiru

[vishsaggi]

Any specific reason or purpose of having 100 columns with same value? Just curious to know the requirement. Can you elaborate a little please ? You mean here 100 rows ?

[antoniotiman]

Hi,

You can use

Mapping Load and ApplyMap

or

LOAD

...

If(Field='USA','America',Field) as Field

From Table;

Regards,

Antonio