Would still be a view you are joining in, but I think a template could simplify the whole thing. Need to test but if we write a template with the join, view + fields, then you’d be able to extend that template with a line just to direct to the desired key.
Much simpler example here: How can I share logic across multiple models? (Hub and spoke)