Lookup Logic

kashif007 · Post by **kashif007** » Mon Mar 12, 2007 3:10 pm

I have got redundant data in my lookup. Due to this its grabbing only the first value and leaving the second one. How can I make the second redundant value as the output as well when I am doing a lookup. Can I do a row wise lookup. Rather than a column wise lookup.

Please help.

panchusrao2656 · Post by **panchusrao2656** » Mon Mar 12, 2007 3:14 pm

you can use a join stage to get all matching records otherwise in the lookup stage use the option return multiple rows from the link you want to get all matches

kashif007 · Post by **kashif007** » Mon Mar 12, 2007 3:24 pm

Yeh "Return Multiple rows" kinda helps. But its giving me output just like a join. But since I am doing a lookup for 22 rows I need to get 22 rows as output. Instead I get 132 rows. Do you suggest anything else.

panchusrao2656 · Post by **panchusrao2656** » Mon Mar 12, 2007 3:27 pm

you mean, you want all 22 matches in 22 columns of the same record.

kashif007 · Post by **kashif007** » Mon Mar 12, 2007 3:31 pm

No no no. Ok you see I have 22 input records, and 14 refrence lookup. All I need is to see the value of one particular record in the reference and get the values associated to it even though its redundant like 5 times. I want to grab only 5 correcponding rows from refrence lookup. Does this helps you. I can give an example if you are confused.

us1aslam1us · Post by **us1aslam1us** » Mon Mar 12, 2007 5:25 pm

Check the other post. I hope that will help.

kumar_s · Post by **kumar_s** » Mon Mar 12, 2007 10:03 pm

Order the lookup data in the other order based on the lookup key as the lookup value.
But give some example to get more details.