What do you mean by "replace" and "100 values"? Can you give us an example?
You might be able to do something like this if you are just removing a bad value.
MyTable: LOAD *, If( SomeValue = 'Bad', 'Now Good', SomeValue ) AS 'CleanedValue' LOAD * Inline [ 'OrderId', 'SomeValue' 1, 'Bad' 2, 'Good' 3, 'Good' ] ;
I have a field with 179 names, some names are for the same people so for example:
John Winston Ono Lenon
John W. Lennon
All those names I'd like to have them as 'John Lennon'. The ideal way is to go to the Data Editor and use the replace function, but as I have more than 100 names I can't do that.
Hope I'm clear this time....
May be like this:
If(Match(Field,'John L','J Lennon','John Winston Ono Lenon','John W. Lennon'),'John Lennon',
If(Match(Field,'John R','J Rennon','John Winston Ono Renon','John W. Rennon'),'John Rennon', 'ABC'))
By using of Match(), MixMatch() functions.
Because one name is having 3 or 4 similar names.