Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

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

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

2 Replies
vishsaggi
Champion III
Champion III

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
Master III
Master III

Hi,

You can use

Mapping Load and ApplyMap

or

LOAD

...

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

From Table;

Regards,

Antonio