Struggling with Searching for Specific Values in Excel – Need Help!

Groups
1

Hello KNIME Community,

I hope everyone is doing well! I’m currently working on a project where I need to search for specific values in an Excel file using KNIME, but I’m running into some challenges.

I’ve tried using some basic search nodes, but I’m not sure if I’m missing something or if there’s a more efficient way to accomplish this. Specifically, I’m trying to search for a particular phone number (or a string of text) across multiple rows, and I want to make sure I’m handling large datasets properly.

If anyone has tips, tricks, or even a workflow to suggest, I’d be so grateful. I’d love to learn from others who have experience with this.

2

Hey @Ariyan,

How are you currently set up with your workflow to do this?

Initial suggestion would be to just read it in via Excel Reader and pass the output to a ‘Row Filter’ where you can select the column you have your phone numbers in.

You can type in the specific number you are looking for and set it to equal that. You can add another one if maybe its of different type like with/without hyphens.

TL

4 Likes