Forum Discussion

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
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 h...
Need Help
Show and Tell
Tips and Tricks
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    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.

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

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.