How to combine two different dimension tables for processing

KNIME Extensions
1

I want to extract the lines of table 1 which contains atleast one word of table two how to extract this

sndfjkn
sndfjkn715Ɨ386 9.9 KB

How to combine these two to process

2

The simplest solution to use Rule-based Row Filter node.
$col0$ like ā€œpriceā€ => TRUE
$col0$ like ā€œtouchā€ => TRUE
$col0$ like ā€œpriceā€ => TRUE
ā€¦

1 Like
3

this is the small table and I want to specify col0(table1) Like column1(table2) in this way

4

Could you upload the examples. It would make evaluating the problem easier.

5

You can achieve your goal by Tagging and Filtering. Here is an example workflow. Hope it helps.
FilterByTagging.knwf (16.2 KB)

1 Like
6

Based on MH example Iā€™d like to hint KNIME development team on interface consistency. In Row Splitter for contains wildcards or regular expression check boxes needs to be changed to radio buttons.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.