https://community.cloudera.com/t5/Support-Questions/Apache-nifi-merge-two-different-csv-file-and-create-combine/m-p/235238#M197058 <P>Hi All,</P><P>I am novice to nifi and want to achieve my task with nifi</P><P>Problem statement :</P><P>I have two csv file 1) Inventory 2) Rate which are in csv</P><P>Both of files have common UNIT_ID (InventoryId)</P><P>Input Inventory File</P><PRE>UNIT_ID|NAME|TOTAL 1111|ABC|90 1112|XYZ|50</PRE><P>Input Rate File</P><PRE>UNIT_ID|TYPE|RATE 1111|ONE|900 1111|TWO|5800 1112|RTY|500</PRE><P>Output Json</P><PRE>[{ "UNIT_ID": "1111", "NAME": "ABC", "TOTAL": "90", "RATES": [{ "TYPE": "ONE", "RATE": "900" }, { "TYPE": "TWO", "RATE": "5800" }] }, { "UNIT_ID": "1112", "NAME": "XYZ", "TOTAL": "50", "RATES": [{ "TYPE": "RTY", "RATE": "500" }] } ]</PRE><P>Please help to find a way to do this, I am able to convert csv to json but stuck with how can I join by unit_id</P><P>Thanks.</P> Fri, 02 Nov 2018 12:57:40 GMT chintan2010visa 2018-11-02T12:57:40Z