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
51 Answer
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.
3
