Hi All, I am novice to nifi and want to achieve my task with nifi Problem statement : I have two csv file 1) Inventory 2) Rate which are in csv Both of files have common UNIT_ID (InventoryId) Input Inventory File UNIT_ID|NAME|TOTAL
1111|ABC|90
1112|XYZ|50 Input Rate File UNIT_ID|TYPE|RATE
1111|ONE|900
1111|TWO|5800
1112|RTY|500 Output Json [{
"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"
}]
}
] 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 Thanks.
... View more
