Forum Discussion
Solved
Custom Column - Value from other query
Hi there, I have added a Custom column to a Quaery (Query 1) in Power Query and I want the value on each row in this column to equal to the value from a single row in another Query (Query 2). ...
Just do this:
Table.AddColumn(PrevStep, “NewColumnName”, each OtherTable[ColumnName]{2})
//{2} being the zero-based position of the other table’s item that you want. You could also do
each OtherTable[ColumnName] = “Some Team”, type text).
Thanks again edhans
The reason I want to be able to get the club name from the other table is because I want to apply this step in multiple queries with different club names and be able to update the source data from say "Club 3" to "Manchester United" and have this flow through all the queries.
So essentially I am trying to find someway to link the two tables so the computer knows to look at Club 3 from the other table.
Thanks.
But why do you expect it to know which is Club 3 vs Club 2? How are you linking the data?