Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate II
1 year ago
Solved

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.

     

1 Reply

  • 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.