Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
Hi,
You can use
Mapping Load and ApplyMap
or
LOAD
...
If(Field='USA','America',Field) as Field
From Table;
Regards,
Antonio