JDBC lookup - matches to list
I'm using JDBC lookup, and my query recovers multiple results. I want to add them as List to each record, the only possibilities in the dropDownList (Multiple Values Behavior) are: 'First value only' and 'Split into multiple records'. Spit into multiple generates new records with repeated data :(
It's supposed to be resolved in this link: https://issues.streamsets.com/browse/... with the option 'Return all matches as lists of values', but I don't see it.
What version of Data Collector are you using?
I'm using the last version 3.3.1. But still can't select 'Return all matches as lists of values' in the dropDownList (Multiple Values Behaviour). Don't know how to resolve this problem.