Search within text within a cell

KNIME Extensions
, , ,
1

I have a table and I want to search within a column and I want my search to be such that if I enter part of the content, it will show me every cell that contains that value I entered
For example, if my phone number was 49123454876, if I enter 54876, it will show me every cell that has this value inside it

1 Like
2

Hi @alex1368,

have you tried the row filter node? It is pretty straight forward and self explaining:

Best, Mike

3 Likes
3

Are you doing it for a Component? Table View can do this out of the box, either globally or per column.

1 Like
4

Can you design a workflow for me?

1 Like
5

Hi @alex1368,

most community members would but, either for the lack of politeness (no accusation, maybe a language barrier), or lack of trying it yourself first, many won‘t.

Don‘t get me wrong, I neither want to discourage nor drive you away but eventually you try one of the excellent courses first:

If you still struggle after trying, you are more than welcome asking for help again :+1:

Cheers, Mike

3 Likes
6

Thanks
With your help I was able to solve the problem.

1 Like
7

Hello dear friend
This model works well in table searches but it does not work when my table is in sql server.
My information and data is in the database and I want to do this search model there. This feature which is available in the regular row filter node is not available in db row filter

8

Hi @alex1368,

there is an equivalent Row Filter node for DBs:

Give it a try but be warry of how DB nodes work.

Cheers
Mike

9

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