Forum Discussion
Repleace values based on other table
Hi Team, I hope you can help me with my problem. I have searched for it but coldn't find perticular answer. I have a table with circa 30 positions where user name was changed from User Name ...
= Table.ReplaceValue(
#"TAT A1",
each [Reviewer],
each #"KN Previous Name List"{[User Name1=[Reviewer]]}[User Name2],
(row, old, new) => try new otherwise old,
{"Reviewer"} )
Stéphane