Hi Sangavi, Good question, I thought it can be a nice example to illustrate how to use LookupService. I wrote a simple Gist entry with a NiFi template file to do what you are looking for.
"Join, Enrich multiple columns by looking up an external CSV file" https://gist.github.com/ijokarumawak/b9c95a0d0c86c97ffeaeb5ef95320b8b I hope you find it helpful. Thanks, Koji On Tue, Jan 30, 2018 at 9:43 PM, Sangavi Eswaramoorthi <[email protected]> wrote: > Hi, > > I would like to join multiple columns to input record using single lookup > service.Is it possible in LookupRecord processor?? > > For Example, > > I have an input csv file with columns. > > File 1: > > Emp_Id,Name,Address,Mobile No > > And another file which is used as input for lookup service, > > File 2: > > Emp_Id,Salary,Department > > I am trying to join salary and department to file 1. > > Expected result: > > Emp_Id,Name,Address,Mobile No, Salary, Department > > Could anyone please help me to achieve this using LookupRecord processor. > > Thanks in advance. > > > Regards, > Sangavi E
