Hi Need help with String comparison. i have following 3 tables. Ask is to compare strings in Table 3 with Strings in Table 1 and 2. If any of the strings from Table 1 and/or 2 matches to Table 3 strings, then create a separate column with matched value from Table 3. Table- 1 dog playful cat fish funny monkey Table- 2 Short Tail long ear Cat cute Table-3 Cat loves dog Dog is as cute as my cat Long ear monkey loves playing with fish. Fishes are cute dog with short tail goofs around Any help with this task is appreciated. thanks

Hi there @Br1jesh , take a look at this topic: [image] row filter KNIME Analytics Platform I have 2 tables and each has one column, I want to filter out rows in the first table in which column value contains any value in column of the second table. Example: Table 1 Rowid Column 1 this is the first row 2 this is the second row 3 this is the third row … n this is the nth row Table 2 Rowid column 1 second 2 fifth my desired result will be without row 2, 5. any suggestions to handle this?… You would need to modify workflow a bit but can help. Br, Ivan

String Comparison and Extractions

KNIME Analytics Platform

ipazin March 5, 2020, 2:07pm 12

Hi there @Br1jesh,

take a look at this topic:

You would need to modify workflow a bit but can help.

Br,
Ivan

3 Likes