I want to replace particular field in data

[Vijayqlik4171]

 i want to change 'UK' instead indo 8 row 

[EliGohar]

@Vijayqlik4171 Do you want to replace the word "indo" with "UK" in the load script?

If so, See the following example I created:

Salaries:
Load * Inline [
id, country, salary
1, india, 100
1, india, 200
2, usa, 300
2, usa, 400
3, japan, 500
3, japan, 600
4, indo, 700
4, indo, 800
];
 
SalariesNew:
Load
  id,
   If([country] = 'indo','UK',country) as [Country],
   salary
Resident Salaries;
drop table Salaries;