Need suggestion for Data Harmonization

Hi Everyone,

I’m trying to harmonize surface treatment data using a Python Script node in KNIME. I have an Excel file with

Key_Word

and

Target

columns, where

Key_Word

includes wildcard characters (e.g.,

*gehrtet*

) to match parts of the text in my main data table. For example, I want to replace

gehrtet und angelassen

with

mechanical treatment

because it contains the

Key_Word

*gehrtet*

. However, despite setting up the script to perform this replacement, no changes are being made to the main data table.

Does anyone know why it is not working or have a different approach to data harmonization?

Thank you in Advance!