How to use a seperate table to fix incorrect data

Question

Good morning&nbsp;I have a table which contains data from a read only sql database.&nbsp;I have learned that some of the data is incorrect, however i cannot access the main database, therefore i wish to correct it using powerquery.&nbsp;The main table data looks like this&nbsp;&nbsp;EngIdFnameLnameEmailAColBcol1ANotherANother@email.comDataMore data2BAlphaBAlpha@email.comDataMore data3CbetaCbeta@email.comDataMore data4DAlphaDAlpha@email.comDataMore data5EbetaEbeta@email.comDataMore data6FAlphaFAlpha@email.comDataMore data7GbetaGbeta@email.comDataMore data8HAlphaHAlpha@email.comDataMore data9IbetaIbeta@email.comDataMore data&nbsp;The correction table looks like this&nbsp;EngIdFnameLnameEmail4NewFNewSNewFNewS@email.com6BAlphaBAlpha@email.com8BAlphaBAlpha@email.com9ANotherANother@email.com&nbsp;Using PowerQ i want to update the main table using the correction table. The correction table will reach about 30 entries, so not horrendous if i have to use code to replace each entry, however I suspect there is an easier way using relationships or code etc. The EngId only contains unique values.&nbsp;In the example, the original values for EngID 4 are D,Alpha, DAlpha@email.com. i want this replaced with the correction value of NewF,News,NewFNewS@gmail.com&nbsp;&nbsp;I appreciate any help.&nbsp;Lola

samwiseowl · Accepted Answer

Hi&nbsp;MyWeeLola&nbsp;&nbsp;You can use the Merge option on the Home tab&nbsp;&nbsp;Click the two columns that overlap, you can even join on multiple columns.&nbsp;Choose the Expand option and tick the columns to bring throughFinally add a column that returns the correct value if there is one.Then delete the unneeded columns:&nbsp;

Forum Discussion

How to use a seperate table to fix incorrect data

2 Replies

Related content

Model composite with seperate table

Periods seperation

Incorrect turnover total

Measure total incorrect in Table

Measure returning incorrect value

EngId	Fname	Lname	Email	ACol	Bcol
1	A	Nother	[email protected]	Data	More data
2	B	Alpha	[email protected]	Data	More data
3	C	beta	[email protected]	Data	More data
4	D	Alpha	[email protected]	Data	More data
5	E	beta	[email protected]	Data	More data
6	F	Alpha	[email protected]	Data	More data
7	G	beta	[email protected]	Data	More data
8	H	Alpha	[email protected]	Data	More data
9	I	beta	[email protected]	Data	More data