Re: Is it possible to filter and eliminate the values in the json data format using the nifi processors

[Manojkumar Ravichandran]

Hi koji,


I have tried the EvaluateJsonPath processor but can't able to produce the
required output,here  the sample Input and required output json file has
been attached

After that i want implement the same scenario with different json or CSV
files, Out thing is to iterate the content of flowfile with each values of
the another CSV or Json file.


Regards,

Manojkumar R

On Mon, Nov 21, 2016 at 5:40 AM, Koji Kawamura <ijokaruma...@gmail.com>
wrote:

> Hi Manojkumar,
>
> To extract elements from a single JSON flow file, then
> EvaluateJsonPath or JoltTransformJSON would be able to do the job.
> Could you share the entire sample input JSON file (including the
> elements you'd like to filter out) ?
>
> Thanks,
> Koji
>
> On Sat, Nov 19, 2016 at 10:27 PM, Manojkumar Ravichandran
> <sendmailt...@gmail.com> wrote:
> > Hi Team,
> >
> > Is it possible to filter and eliminate the values in the json data format
> > using the nifi processors
> >
> > Note:I have used some processor like extract text,Attribute
> > json,EvaluateJsonpath , but I can't able to generate the required output
> >
> > For Example:
> > I getting a separate flow files like this,from the json data fetched
> > {
> > "YEAR": "2015",
> > "Month": [{
> > "MONTH": "Jan",
> > }]
> > }
> >
> > {
> > "YEAR": "2016",
> > "Month": [{
> > "MONTH": "feb",
> > }]
> > }
> >  the output I need should be in the form of given below,
> > {
> > "Year": 2016,
> > "Months": [{
> > "Month": "Jan",
> > },
> > {
> > "Month": "Feb",
> > }]
> > }
> >
> >
> > Regards,
> > Manojkumar R
>

SampleInput.json
Description: application/json

sampleOutput.json
Description: application/json