Dictionary string manipulation on multiple columns

Hello,

I have a dictionary containing several “search-replace” string pairs that I would like to use to modify several columns. I am able to write the flow variable replace expression for each dictionary entry and apply to multiple columns (via Multicolumn String Manipulation) but I cannot get the structure of the loop right…

image

… in this way the inital table is reapeted n times where n is the number of dictionary entries and I have only one string manipulation done per block. I need to apply consequently each manipulation to the same table.

Do I need to code this in Java?

L.

I think one option would be a recursive loop where you only keep the last iteration.
You could also have a look at string replace (Dictionary)
br

3 Likes

Thanks… key was to take only the final iteration and I have done it:


Not so easy to configure the end condition flow variables (I was trying hard to have a boolean variables then I discovered they don’t exist in Knime - node documentation shall be improved).

I don’t use the String Replace Dictionary because it works only with input files and not in tables :frowning:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.