Forum Discussion
Replace value from another table if the columns appear
Hi there! I have 1st table here with some incorrect data and would like to replace it based on the 2nd table. The value in red font is wrong, the correct data is in 2nd table. I would ...
suppose the bound value of year and ID in table 2 is unique, you can try this code.
NewStep in Table1=Table.FromRecords(Table.TransformRows(Table1,each _&(Table2{[Year=[Year],ID=[ID]]}? ??[])))
wdx223_Daniel
Community Champion
Community Championsuppose the bound value of year and ID in table 2 is unique, you can try this code.
NewStep in Table1=Table.FromRecords(Table.TransformRows(Table1,each _&(Table2{[Year=[Year],ID=[ID]]}? ??[])))