Sorry, misread which processor you're using. You'd want to use LookupRecord with my suggestion.
On Wed, Apr 11, 2018 at 9:40 AM, Mike Thomsen <[email protected]> wrote: > If you know a scripting language that's supported, you can use the > ScriptedLookupService to tailor the behavior to your exact specification. > The dynamic properties also support EL, so depending your use case you > might be able to leverage that. > > Ex of a Groovy script built for ScriptedLookupService: https:/ > /gist.github.com/alopresto/78eb1a2c2b878f75f61481269af38a9f > > On Wed, Apr 11, 2018 at 6:19 AM, françois lacombe < > [email protected]> wrote: > >> Hi all, >> >> This morning, i'm trying to update records from a csv file prior to send >> them in a pgsql db. >> The UpdateRecord processor sounds to be the most useful to do so. >> >> Given problem is I have to replace values of some columns, depending of >> current value: >> 1 => a >> 2 => b >> 3 => c >> ... >> 10 => j >> >> UpdateRecord actually accepts custom properties to set a unique value of >> a given key (with Literal replacement strategy) but how can I provide a >> kind of map of values depending of existing? Is this even possible ? >> >> I thought of a combination of RouteOnAttribute and UpdateRecord >> processors but this would lead to dozen of processors in my pipeline since >> I have approximately 50 different replacement to make. >> I hope I won't have to choose this option :) >> >> >> Thanks in advance for any input, all the best >> >> François Lacombe >> > >
