Need suggestion for Data Harmonization

[stanymathew]

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!

[ActionAndi]

Hi,
I do not get it fully. The Excel-File give the “Key_word” and “Target” columns.
What should happen?

1. It searches in a column “Target” for the “Key-Word”?
2. it searches in a column with a other name for rows with “Key-Word” and replaces it with the “target”?
3. both?

The String Replacer (Dictionary) works like 2).

Setting is: