@G47_2 , that’s great. I added a slight mod to yours [your first post], for the benefit of the OP to get the full result back as per the Column A,B,C but both your and @ipazin’s workflows have provided new insights, which is what this is all about! 
KNIME_ref_data_partial_match_g472_2.knwf (13.3 KB)