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