map field from other table without having a relation, multiple hits and default value if not found

[amien]

product	value
1	155
2	160
3	170
4	100

product	code
1	A
1	B
2	C
3	D

As you can see. Where product = 1, there are two results and where product = 4 there is not hit.

I would like to have this result:

product	value	code
1	155	A
2	160	C
3	170	D
4	100	Unknown

Is it possible to create the code field in the first table within the Query editor?

[ChrisMendoza]

Seems to be a duplicate of https://community.powerbi.com/t5/Desktop/Is-it-possible-to-map-field-values-and-return-only-1-result.... See response and attachment.