Can you try with this?
UPDATE revenue_data SET gtm_type = p.type FROM ( SELECT DISTINCT pl, type FROM emea.product WHERE type = 'value1' ) p WHERE revenue_data.pl = p.pl;
or You Want to Dynamically Set gtm_type to the Matching type?