A lot of the data we get is very dirty and in need of cleanup to such a point that UpdateRecord cannot handle it. So we use lookup services and LookupRecord to do things like normalize certain fields that are often wildly off from what we need. I wrote this processor over the weekend, and am wondering if I should add it to a PR:
https://github.com/MikeThomsen/nifi-record-enhancement-bundle It's similar to LookupRecord, but it's designed for one purpose: let a user apply a bunch of cleanup tasks in a single hop through the NiFi graph. Any interest? Thanks, Mike