I am not able to resolve this issue
source ---> source.xls
lookup ---> test.xls
target --> target.xls
From the source file i need to look into lookup i.e test file and i have to get the result i.e target.csv.. I should avoid multiple lookups for each column.. Actually we have more than 15 columns like this M1,M3,and so on..
How can we do this I am not able to get any idea can anyone suggest me how to do avoid multiple lookups and get the result?
Any help is appreciated...