Forum Discussion
Using a mapping table to replace multiple values in multiple columns
Hi all, I'm trying to use a mapping table to replace multiple values in multiple columns. My table looks like this Person Question1 Question2 Question3 Juan Si No Si Joe Yes Ye...
= Table.ReplaceValue(#"Changed Type","","",(x,y,z)=>Table2{[Old=x]}?[New]? ??x,{"Question1", "Question2", "Question3"})
how does this function work?
I'd like to take only the first 5 characters of the values, compare them with "old" and if they match take the value "new", otherwise keep "old". Is this possible by using the (x,y,z) function?