Right now I have 60 “String Replacer” nodes. Each coded to a different disease. Theres gotta be a better way to do this, right? Its really cumbersome to manage all of these separate nodes.
you could also find the minimal string needed to identity your disease and then use a wildcard pattern in the “string replacer” node. Hard to give a better solution without knowing more about the dataset.
izaychik63 - I tried the rule engine but it deletes entries that don’t need cleaning. So my column I’m trying to clean ends up depopulated.
scapuzzi - That’s the method I have been using. The problem is I have ~60 individual nodes (one for each search term). Is there a way to use a table of search terms with wildcards?
scottF - Thanks for the suggestion. I must admit I am not sure how to implement this to do what I need but I can see how something like this would be powerful.