Need suggestion for Data Harmonization

KNIME Analytics Platform
1

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!

image

image
image995×246 18.1 KB

2

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).

image
image962×573 126 KB

Setting is:

image
image664×979 72.8 KB

1 Like