Addcolum from another table using Power Query

[Anonymous]

I need to add a column from another table in Power Query Editor becuase I dont want some records in table and data is normalized.

See below

Table A			Table B
Field1	Field2		Fruit	Color
Cherry	2		Plum	Red
Apple	4		Peach	Orange
Grape	2		Cherry	Red
Plum	5		Apple
Peach	1		Watermelon	Yellow
			Grape	Green
Table A
Field1	Field2	NewField-Color
Cherry	2	Red
Apple	4
Grape	2	Green
Plum	5	Red
Peach	1	Orange
Then I want to delete records that are blank and Green     (I can do this part with the filter)
Table A
Field1	Field2	NewField-Color
Cherry	2	Red
Plum	5	Red
Peach	1	Orange

[Anonymous]

works great  thnk you

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file with the data and query shown below

In Power Query, Merge the tables using a Left Outer Join.

Regards

Phil