Searching for text pattern in DB columns and set its flags

[bvirulkar]

Hi,

I am a beginner in RapidMiner. I have MS SQL Server database. It contains two tables. One has information and other table contains keywords. The information is present in multiple columns in first table. My requirement is I want to scan those coulmns for the all keywords present in table2 and if more than 75% keywords are present for that row in table1 then I want to update the third table.

Can this complete process be achieved in rapid miner? if Yes, can someone tell me how?

Thanks in advance.

Bhushan