Re: [Nifi 1.5.0] Map values to be replaced in a UpdateRecord processor

[Mike Thomsen]

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 
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 <
> francois.laco...@dcbrain.com> 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
>>
>
>

Re: [Nifi 1.5.0] Map values to be replaced in a UpdateRecord processor

[Mike Thomsen]

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 <
francois.laco...@dcbrain.com> 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
>

[Nifi 1.5.0] Map values to be replaced in a UpdateRecord processor

[françois lacombe]

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