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.
Mapping using Hashed file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: