question Re: How to use processor ReplaceWithMapping in nifi? in Archives of Support Questions (Read Only)

How to use processor ReplaceWithMapping in nifi?

rabitbani — Mon, 22 Aug 2016 17:44:16 GMT

I have splited data json like this:

{"id":"TSO31101","year":"1992","name":"SDN","npsn":"20211628"}

I want to replace "SDN" and "TSO31101" contents using processor ReplaceTextWithMapping

my mapping file content like this:

SDN<tab>SD

TSO31101<tab>AAAA

how it is work?

bwalter1 — Mon, 22 Aug 2016 20:03:27 GMT

I not sure ReplaceWithMapping is powerful enough ...

I would anyhow prefer a solution like this (look at the edited answer at the bottom):

You have more control which values of which keys you actually replace and you can replace multiple values in one record

rabitbani — Tue, 23 Aug 2016 14:06:41 GMT

The result from ExecuteScript Groovy is:

{bentuk=SD, field2=cd, field3=A2}

Can I get the output with the json format?

thanks for your solutions, im looking forward for your reply 🙂

bwalter1 — Wed, 24 Aug 2016 20:45:46 GMT

Replace

outputStream.write(inJson.toString().getBytes(StandardCharsets.UTF_8))

def outJson = new JsonBuilder(inJson)
outputStream.write(outJson.toString().getBytes(StandardCharsets.UTF_8))

The referenced sample in StackOverflow already imports jsonBuilder