multiple columns need to be lookup one table
Posted: Thu Aug 07, 2008 3:26 am
Hi,
Can you please give the suggestion for the below task,
my source:(file)
month1,month2,month3,month4--columns
1,2,3,4
2,1,3,4 ---data
Lokup table:
months:
1
2
3
So my requirement is i need to check the each column from the source to lookup column and pass the record to target,
is it possible take one lookup satge and send the data to target?
Can you please give the suggestion for the below task,
my source:(file)
month1,month2,month3,month4--columns
1,2,3,4
2,1,3,4 ---data
Lokup table:
months:
1
2
3
So my requirement is i need to check the each column from the source to lookup column and pass the record to target,
is it possible take one lookup satge and send the data to target?