Insert column in Tables, using values from another column

[monojchakrab]

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 insert a column which will populate the new column with the corresponding name under the column [Account]. E.g. In the 1st table, from the [Data] column, I would like to insert a column, filled with the account name, "JioMart"

If I simply use Table.AddColumn, I am getting an error.

Is there a way to solve this in power query?

Any help much appreciated

[monojchakrab]

@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?

[wdx223_Daniel]

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

[wdx223_Daniel · Accepted solution]

NewStep=Table.ReplaceValue(PreviousStepName,each [Account],"",(x,y,z)=>Table.AddColumn(x,"Account",each y),{"Data"})