Can knime accomplish this task?

[lichang]

Dear everyone

First, can I find the same words and display them? For example (3,2)

Second, can I insert all the words in target 2 into target 1? Such as (3,3)

If possible, please let me know, thanks.

[dnaki]

Hi.
The solutions I present here do not use any of the text mining nodes, but rather regular data manipulation nodes.
The first task is relatively easy. Use the Cell Splitter node to create a set of words for target 1 and target 2 then use the column aggregator node to find the intersection of the 2 sets.

The second task is more challenging. I got very close (see screenshot). I avoided scripting nodes; there may be a more elegant solution, but this works. I’ll leave it to you to modify as you like.
Please see attached workflow.

set operations.knwf (33.1 KB)

[lichang]

Thank you very much, exactly what I wanted, I love you and love this community. Thank you

[lichang]

Maybe this is a stupid question but I don’t know how to implement it with knime.
:I don’t know how to merge the data in 1(3,1) and 2(3,2)into a new cell.

Hope you have time to help me. Thank you in advance.

[dnaki]

Hi. Use the GroupBy node (don’t specify a grouping though) to aggregate the Concatenate (combined string) column using the “concatenate” aggregation with no delimiter
Hint: The GroupBy node is well worth learning and understanding well.

Note: I added a String Manipulation node to insert a new line between the rows to be combined, but if you don’t want a new line, just remove the String Manipulation node.
combine rows.knwf (8.0 KB)

[lichang]

@dnaki

符串操作节

thank you very much.