Is it possible to join multiple columns to a record using single lookup service

[Sangavi Eswaramoorthi]

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