Forum Discussion
Solved
Update column with PQuery
Hi, How can I update,with powerquery, the first column of the attached photo with the data of the second if the value is different? Tnks a lot Gianni
Are the columns already in one table?
If not merge the two tables in power query on a common set of columns.
You can then create custom columns with if statements that take the 2nd value unless it's null in which case use the 1st.
Finally remove the old columns and renames the new ones correctly.
