Lookup to multiple rows
Posted: Mon Jul 18, 2005 3:17 pm
Hi,
I've a scenario in look up as stated below.
Source link
Crse_CD Col1 Col2 Col3 Col4 Col5
M10001 1 a c c b
M20001 4 s d d d
Look up
Crse_cd
M10001
M10001
M10001
M20002
M20002
I've to do a look up on Crse_cd column and divide my source in to no of occurence of Crse_cd in look up link i.e. M10001 comes 3 times in lookup and M20002 comes 2 times so my o/p should be 3rows(M10001)+2rows(M20002) = 5 rows of data.
Can anybody help on this .
Thanks in advance.
Regards,
Munish
I've a scenario in look up as stated below.
Source link
Crse_CD Col1 Col2 Col3 Col4 Col5
M10001 1 a c c b
M20001 4 s d d d
Look up
Crse_cd
M10001
M10001
M10001
M20002
M20002
I've to do a look up on Crse_cd column and divide my source in to no of occurence of Crse_cd in look up link i.e. M10001 comes 3 times in lookup and M20002 comes 2 times so my o/p should be 3rows(M10001)+2rows(M20002) = 5 rows of data.
Can anybody help on this .
Thanks in advance.
Regards,
Munish