Forum Discussion
MyWeeLola
Helper II
Helper IIHow to use a seperate table to fix incorrect data
Good morning I have a table which contains data from a read only sql database. I have learned that some of the data is incorrect, however i cannot access the main database, therefore i wish t...
Hi MyWeeLola
You can use the Merge option on the Home tab
Click the two columns that overlap, you can even join on multiple columns.
Choose the Expand option and tick the columns to bring through
Finally add a column that returns the correct value if there is one.
Then delete the unneeded columns:
MyWeeLolaHelper II
Helper II
Seems simple when you put it like that:) Thank you very much and I appreciate you taking the time to show me.
Lola