hi, I have a problem with the code below. The reason is because one coulmn's title contains brackets. Can you pls tell me how should I writhe the below code?
Columns' names are: "Gender (t)" and "Surname t"
= Table.ReplaceValue(Źródło,each [Gender (t)],each if [Surname t] = "Manly" then "Male" else [Gender (t)],Replacer.ReplaceValue,{"Gender (t)"})
Bookmarks