Ask Your Question
1

JDBC lookup - matches to list

asked 2018-07-20 12:34:15 -0600

lucaz248 gravatar image

updated 2018-07-20 14:58:27 -0600

metadaddy gravatar image

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.

edit retag flag offensive close merge delete

Comments

What version of Data Collector are you using?

metadaddy gravatar imagemetadaddy ( 2018-07-20 12:36:51 -0600 )edit

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.

lucaz248 gravatar imagelucaz248 ( 2018-07-20 17:52:53 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-07-20 18:26:43 -0600

metadaddy gravatar image

Unfortunately, this behavior is not currently supported in the JDBC Lookup processor. Please watch/vote/comment on SDC-6480.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-20 12:34:15 -0600

Seen: 89 times

Last updated: Jul 20