Member since
12-20-2021
2
Posts
0
Kudos Received
0
Solutions
02-15-2022
02:11 AM
Hi Yamaga, Basically all lookup services in NIFI does not return multiple rows. In my case i wanted out put in json, so I had converted csv lookup file using JOLT transfomation to have key:[jsonArray], with this i used properties lookup and I got the required output. Thanks Ansar
... View more
12-20-2021
10:46 PM
Hi I have input.csv and Lookup.csv. I have multiple matching records in Lookup.csv. After lookup how do i get all the related records from Lookup.csv. Below is my requirements. Please help me finding solution for this, any suggestions will be of great helpful to me, Thanks in advance for you time and suggestions, With CSVRecordLookupService, im getting only last record in lookup.csv input.csv col1,col2,col3,col4 col1,2,col3,col4 col1,4,col3,col4 col1,6,col3,col4 col1,8,col3,col4 Lookup.csv col2,col5,col6,col7,col8 2,abc,China,123,col8 4,def,USA,118,col8 8,qwe,Canada,118,col8 8,zyx,England,118,col8 Output as json [ { "col1" : "col1", "col2" : "8", "col3" : "col3", "col4" : "col4", "col6" : null, "sub" : [{ "col5":"qwe", "col6":"Canada", "col7":"118", "col8":"col8" },{ "col5":"zyx", "col6":"England", "col7":"118", "col8":"col8" }] }, { "col1" : "col1", "col2" : "2", "col3" : "col3", "col4" : "col4", "col6" : null, "sub" : [{...}] } ]
... View more
Labels:
- Labels:
-
Apache NiFi