https://community.cloudera.com/t5/Support-Questions/flatten-json-using-nifi/m-p/218726#M180627 <A rel="user" href="https://community.cloudera.com/users/13723/chrisherssens.html" nodeid="13723" target="_blank">@chris herssens</A><P>After convert Avro to json processor use <STRONG>SplitJson</STRONG> processor with below configurations in it, if your data is having <STRONG>json Array</STRONG> then <STRONG>SplitJson</STRONG> processor <STRONG>split the array</STRONG> and every <STRONG>flowfile</STRONG> would be <STRONG>single record</STRONG>.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="40809-splitjson.png" style="width: 527px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/16050i4FE18A74ECA2C364/image-size/medium?v=v2&amp;px=400" role="button" title="40809-splitjson.png" alt="40809-splitjson.png" /></span></P><P>then use <STRONG>JoltTransform</STRONG> processor to flatten the json record.</P><P><STRONG><U>Flow:-</U></STRONG></P><PRE>ConsumeKafka--&gt; convertAvroToJSON--&gt;SplitJSON--&gt;JoltTransform</PRE> Sun, 18 Aug 2019 02:47:23 GMT Shu_ashu 2019-08-18T02:47:23Z