Mapping using Hashed file
Posted: Thu Jul 23, 2009 10:12 am
Hi,
I am using a source file which has different columns like code1,code2,code3..and i have a XLS file which has code and description as columns. I need to design a job which can take the values from the XL file.
So what i am planning to do is extracting this XL file as a CSV run DS JOB and create a hash file. Planning to use this as a lookup file and map the column values.
But when i am trying to do this it is taking only the values which are read first ie., code2,code3 are getting the valuse of code1.
Can anyone suggest a process how to implement this with DS JOb.
I am using a source file which has different columns like code1,code2,code3..and i have a XLS file which has code and description as columns. I need to design a job which can take the values from the XL file.
So what i am planning to do is extracting this XL file as a CSV run DS JOB and create a hash file. Planning to use this as a lookup file and map the column values.
But when i am trying to do this it is taking only the values which are read first ie., code2,code3 are getting the valuse of code1.
Can anyone suggest a process how to implement this with DS JOb.