Forum Discussion
Solved
Insert column in Tables, using values from another column
Hiya good people, I am trying to solve, possibly a wierd problem. I have a table as below : What I want to do is as follows : In each of the table under the [Data] column, i want to...
NewStep=Table.ReplaceValue(PreviousStepName,each [Account],"",(x,y,z)=>Table.AddColumn(x,"Account",each y),{"Data"})
wdx223_Daniel - That worked like a charm, although I could not understand the logic fully...
E.g. how is the function getting its values for x,y & z?
the 4th parameter of Table.ReplaceValue is a function of Replacer.ReplaceText or Replacer.ReplaceValue
and, about the syntax of those function you can refer to this site.
https://learn.microsoft.com/en-us/powerquery-m/replacer-functions