Join collection column with integer

[aworker]

Hi @nojusas and welcome to the KNIME forum

There is a very similar question to yours whose solution could be of help:

Join on partial string match, or Join if string is element of a larger string

Hi @Residentstiefel My suggestion here would be to convert the concatenated keys of first table into a collection (list) of values using the cell splitter but checking the option to generate a single column with a collection of values. Then I would use ungroup, do the joining and then group again if needed. The idea is here but if not clear enough, just tell me please and I’ll be happy to provide the workflow solution. Hope this helps. Best Ael

In essence, you need to ungroup first, do the joining and eventually groupby again to obtain the expected result.

Hope this helps.
Best

Ael