Stream lookup in PENTAHO Data Integration

Question

Is it possible to get multiple result rows after evaluating a stream lookup step in Pentaho Data integration ? I have been trying this thing using a excel input file. But the result set always contains one row. Actually there are more rows to be displayed as result. Please help

Do you mean your stream lookup step only produces one row total, or that it only produces one output row for each input row? — Brian.D.Myers
6 rows are added as input and 3 rows must be output. But in this case only one row is given as output — Rejoy Sebastian
You get rows from your Excel file based on keys that flow through the Stream Lookup step. Where do the keys come from? Another Excel file? — Brian.D.Myers
its from previous transformation. using get rows and select values — Rejoy Sebastian
Then I believe @Codek's answer is the best approach. You can use another Select Values after the Merge Join to remove columns you don't want, or just don't use them. — Brian.D.Myers

Codek Codek · Accepted Answer · 2013-08-25T08:01:35

You want to do a join not a lookup of a single value. So if for the current row the lookup matches 2 values you want 2 rows right? So use the merge join step instead. You'll need the incoming rows in both streams sorted on the key which can be a pain if you're processing huge amounts of data but thats the way to do it.

Stream lookup in PENTAHO Data Integration

1 Answers