Partial match between 2 tables
Hey All,
I’m a new knime user and I’m struggling with doing a partial match between 2 tables.
In ‘table 1’ I only have 1 column; in ‘table 2’ there are 2 columns.
Table 1
Type
Premium customer
Plus prospect
Platina buyer
Table 2
Grade ; Level
Premium ; C-level
Plus ; B-level
Platina ;A-level
I would like to do a partial match based on the values that can be found in ‘Table 1’ and append that with the Grade and Level info.
Can someone help me out with this?
Many thanks,