Forum Discussion
rmcgrath
1 year agoAdvocate II
Trying to fix bad data
I am trying to fix 12 bad records within a fairly large dataset. I have them extracted in an Excel file (as a correction table). I figured I would start a Correction Table because I will probably have more bad records in the future.
My question is this: what is a good way to replace the 12 records in the original fairly large table with the corrected data? The Correction Table has the exact same Headers as the Original Table.
hi rmcgrath ,
in Power Query, try to
1. merge the dataset with the correction table,
2. expand the correct column and
3. delete the original column.