Hi, I am newbie to KNIME and this is my first post.
I am trying to replace content in a data set with 3 columns that looks like this:
CAR MAKER MODEL SENTENCE
Ford Mondeo The 1995 Ford Mondeo was a great car…
Mercedes A Class The german producer has brought a new A Class
VW Polo Ultimately, the Polo is all new
The need is to look at the two columns (Car maker & Model) and if one or the two words appear in the Sentence column, to replace the keywords by “VEHICLE”. A kind of removal of car attributes so that the sentence is neutral.
Expected result:
CAR MAKER MODEL SENTENCE
Ford Mondeo The 1995 “VEHICLE” “VEHICLE” was a great car…
Mercedes A Class The german producer has brought a new “VEHICLE”
VW Polo Ultimately, the “VEHICLE” is all new
Thank you for your help!